SELECT Syntax Elements - Analytics Database - Teradata Vantage

SQL Data Manipulation Language
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
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.