SELECT Syntax Elements - Teradata Vantage

request_modifier

Optional clauses that modify the SELECT statement using one or more of these request or statement modifiers:

Request and statement modifiers apply to all statements in a request.

For information on this statement, see SELECT ... INTO.

AS JSON

See AS JSON.

select_list

See Select List Syntax.

FROM_clause

See FROM Clause.

WITH_clause

See WITH Modifier.

WHERE_clause

See WHERE Clause.

GROUP_BY_clause

See GROUP BY Clause.

HAVING_clause

See HAVING Clause.

QUALIFY_clause

See QUALIFY Clause.

SAMPLE_clause

See SAMPLE Clause.

EXPAND_ON_clause

See EXPAND ON Clause.

ORDER_BY_clause

See ORDER BY Clause.