What are the type of SUB-QUERy?

What are the type of SUB-QUERy?

There are many 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,
> Multiple column sub-query : where the  Sub-query returns multiple columns.

Date:2010-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher