What are the properties and different Types of Sub-Queries?

What are the properties and different Types of Sub-Queries?

General Asked on September 14, 2019 in Interview.
Add Comment
1 Answer(s)
  1. Properties of Sub-Query
    1. A sub-query must be enclosed in the parenthesis.
    2. A sub-query must be put in the right hand of the comparison operator, and
    3. A sub-query cannot contain an ORDER-BY clause.
    4. A query can contain more than one sub-query.
  2. Types of Sub-Query
    1. Single-row sub-query, where the sub-query returns only one row.
    2. Multiple-row sub-query, where the sub-query returns multiple rows,. and
    3. Multiple column sub-query, where the sub-query returns multiple columns
General Answered on September 14, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.