17.05 - SELECT Syntax Elements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)
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 Teradata Vantage™ - SQL Stored Procedures and Embedded SQL , B035-1148 .
WITH DELETED ROWS
See WITH DELETED ROWS.
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.