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