|
INTERVIEW QUESTIONS
DATABASE
SQL
DETAILS
Question: What are the properties and different Types of Sub-Queries?
Answer: Properties of Sub-Query A sub-query must be enclosed in the parenthesis. A sub-query must be put in the right hand of the comparison operator, and A sub-query cannot contain an ORDER-BY clause. A query can contain more than one sub-query. Types of Sub-Query Single-row sub-query, where the sub-query returns only one row. Multiple-row sub-query, where the sub-query returns multiple rows,. and Multiple column sub-query, where the sub-query returns multiple columns
|
|
|
Category |
SQL Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7939 users |
Added on |
5/9/2016 |
Views |
67246 |
Rate it! |
|
|
Question:
What are the properties and different Types of Sub-Queries?
Answer:
Properties of Sub-Query A sub-query must be enclosed in the parenthesis. A sub-query must be put in the right hand of the comparison operator, and A sub-query cannot contain an ORDER-BY clause. A query can contain more than one sub-query. Types of Sub-Query Single-row sub-query, where the sub-query returns only one row. Multiple-row sub-query, where the sub-query returns multiple rows,. and Multiple column sub-query, where the sub-query returns multiple columns Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is difference between DELETE and TRUNCATE commands ?
|
View Answer
|
|
What are the different index configurations a table can have?
|
View Answer
|
|
What is the command used to fetch first 5 characters of the string?
|
View Answer
|
|
How can you create an empty table from an existing table?
|
View Answer
|
|
What is Union, minus and Interact commands?
|
View Answer
|
|
What are the types of subquery?
|
View Answer
|
|
What are the types of join and explain each ?
|
View Answer
|
|
How to get short name & long name of the month or month of given date
|
View Answer
|
|
Identify error in following SQL: SELECT EMPNO, SUM(SAL) FROM EMP GROUP BY EMPNO HAVING ENAME= ‘KENT’ a) Syntax Error b) SUM() is not an aggregate function c) HAVING can not be used with GROUP BY d) The Having condition has to be based on some column that appears in the select list.
|
View Answer
|
|
given a table of student(rollno,name,dno,dateofadmission,city) and department(dno,dname)...How u will found the rollno,class,deptname of students in ascending order of their departments?
|
View Answer
|
|
What is the difference between "select * from table name" and "select column_name from table name" The above quiries are simple select quiries without having any "where" clause. Secondly which query will be performed faster and why??
|
View Answer
|
|
What are SQL Server 2000 and 2010?
|
View Answer
|
|
Can we connect two different relational tables from different data sources and get the output as one flat file?
|
View Answer
|
|
What are the tables and structures in database?
|
View Answer
|
|
How can we delete records in a table using update table?
|
View Answer
|
|
Table1
Date Inv No. Sr.No.
01/04/2009 1 1 01/04/2009 2 2 0304/2009 3 1 04/04/2009 4 1 04/4/2009 5 2
table2 01/04/2009 1 1 01/04/2009 1 1 01/04/2009 1 1 01/04/2009 2 2 01/04/2009 2 2 01/04/2009 2 2 0304/2009 3 1 04/04/2009 4 1 04/04/2009 4 1 04/4/2009 5 2
I want sql query or PL/SQL Block to update the Sr.No. field automatically as shown in the above tables. Sr.No is not entered Manually. This sr.No. should be updated by selecting the date range i.e. from date and two date.
|
View Answer
|
|
How do we select the employees detail from the table who were joined in the last 5yrs?
|
View Answer
|
|
State some reasons for lack of portability?
|
View Answer
|
|
State about some criticisms of SQL?
|
View Answer
|
|
Explain about Data definition?
|
View Answer
|