Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Querying and Modifying Data » Using subqueries » Introduction to subqueries


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