Defines part or all of a query expression.

See: query-expression
SELECT Statement


SELECT <DISTINCT> object-item<, … object-item>
<INTO :macro-variable-specification <, … :macro-variable-specification>>
FROM from-list
<WHERE sql-expression>
<GROUP BY group-by-item <, … group-by-item>>
<HAVING sql-expression>


A table expression is a SELECT statement. It is the fundamental building block of most SQL procedure statements. You can combine the results of multiple table expressions with set operators, which creates a query expression. Use one ORDER BY clause for an entire query expression. Place a semicolon only at the end of the entire query expression. A query expression is often only one SELECT statement or table expression.