SELECT Syntax Elements - Advanced SQL Engine - Teradata Database

SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qtb1554762060450.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1146
lifecycle
previous
Product Category
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 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.