QUERY specifications ( named query spec ) are required to generate an unordered result table in a SELECT statement (named select statement). A QUERY specification is part of the syntax in a QUERY term (named query term).

distinct spec, result table name, select column, table expression

A QUERY specification specifies a result table with the name result table name . The result table is generated from a temporary result table. The temporary result table is the result of the table expression.