Advanced SQL Engine Analytic Function Syntax | Teradata Vantage - 17.05 - Function Syntax Descriptions - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K

SELECT Statement Clauses

The function syntax descriptions in this document are SQL SELECT statements. For simplicity, the descriptions do not show every possible SELECT statement clause. However, you can use any valid SELECT statement clauses. For information about SELECT statement options, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.

Many examples in this document use ORDER BY clauses that the function syntax descriptions do not show.

Function Syntax Element Order

Function syntax elements must appear after the USING clause, but they need not appear in the order shown in the function syntax description.

Many examples in this document do not specify their syntax elements in the order shown in the function syntax description.