LAG and LEAD Expression Rules - Teradata® Database
Database Analytic Functions
- Product
- Teradata® Database
- Release Number
- 17.10
- Published
- July 2021
- Language
- English (United States)
- Last Update
- 2021-07-28
- dita:mapPath
- Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
- dita:ditavalPath
- Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
- dita:id
- B035-1206
- lifecycle
- previous
- Product Category
- Teradata Vantage™
- 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.