SQL Statements › SELECT › Subselect › Description

Description

A subselect specifies a result table derived from the tables or views identified in the FROM clause. The derivation can be described as a sequence of operations in which the result of each operation is input for the next.

The sequence of the hypothetical operations is:

1. FROM clause
2. WHERE clause
3. GROUP BY clause
4. HAVING clause
5. SELECT clause

Descriptions of these clauses appear in the order as previously listed.