1.

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

Properties of Sub-Query

Types of Sub-Query


Discussion

No Comment Found

Related InterviewSolutions