Cumulative, group, moving, or remaining computation of an aggregate function.
- Window Specification Syntax
- Type of Computation
- Arguments to Window Aggregate Functions
- Window Aggregate Functions Result Type and Format
- Result Title
- Window Specification and Missing Data Points
- Nesting Aggregates in Window Functions
- Teradata-Specific Alternatives to Ordered Analytical Functions
- Teradata-Specific Functions and ANSI SQL:2011 Window Functions
- GROUP BY Clause
ANSI Compliance
This statement is ANSI SQL:2011 compliant, but includes non-ANSI Teradata extensions.
In the presence of an ORDER BY clause and the absence of a ROWS or ROWS BETWEEN clause, ANSI SQL:2011 window aggregate functions use ROWS UNBOUNDED PRECEDING as the default aggregation group, whereas Teradata SQL window aggregate functions use ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING.