Contents Index Column names in expressions IF expressions

ASA SQL Reference
  SQL Language Elements
    Expressions

Subqueries in expressions


A subquery is a SELECT statement that is nested inside another SELECT, INSERT, UPDATE, or DELETE statement, or another subquery.

The SELECT statement must be enclosed in parentheses, and must contain one and only one select list item. When used as an expression, a subquery is generally allowed to return only one value.

A subquery can be used anywhere that a column name can be used. For example, a subquery can be used in the select list of another SELECT statement.

For other uses of subqueries, see Subqueries in search conditions.


Contents Index Column names in expressions IF expressions