Categorization of subqueries

Subqueries can be categorized in different ways:

  • whether they can return one or more rows (single-row vs. multiple-row subqueries)
  • whether they are correlated or uncorrelated
  • whether they are nested within another subquery

Single-row and multiple-row subqueries
Correlated and uncorrelated subqueries
Nested subqueries