17.05 - LAG and LEAD Expression Rules - 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
  • A symbol definition can have multiple LAG and LEAD expressions.
  • A symbol definition that has a LAG or LEAD expression cannot have an OR operator.
  • If a symbol definition has a LAG or LEAD expression and the input is not a table, you must create an alias of the input query, as in LAG and LEAD Expressions Example: Alias for Input Query.