What Are The Different Types of Sub-Queries? | SQL Server Interview Question

,
  • 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