WITH Clause Syntax | SQL SELECT Statements | Teradata Vantage - WITH Clause Syntax - 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-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™
WITH expression_1 [,...] [ BY by_expr [,...] ] ] [...]

Syntax Elements

expression_1
An introduction to the condition to be fulfilled by the SELECT statement. Specifies a summary line, such as a total, for the values in a column of the select result. expression_1 can contain one or more aggregate expressions that are applied to column values.
You cannot include LOB columns in the WITH expression_1 list.
You cannot include a WITH clause with NORMALIZE.
by_expr
expression_2 [ ASC | DESC ]
expression_2
One or more result expressions for which expression_1 is provided. BY is valid only when used with WITH.
expression_2 can refer to an expression in the select expression list either by name or by means of a constant that specifies the numeric position of the expression in the expression list. It can also refer to a scalar subquery.
You cannot include LOB columns in the BY expression_2 list.
ASC
Results are to be ordered in ascending sort order.
If the sort field is a character string, the system orders it in ascending order according to the definition of the collation sequence for the current session.
The default order is ASC.
DESC
Results are to be ordered in descending sort order.
If the sort field is a character string, the system orders it in descending order according to the definition of the collation sequence for the current session.