The following sections describe ordered analytical functions and window aggregate functions.
- Ordered Analytical Functions
- Characteristics of Ordered Analytical Functions
- Window Feature
- Window Aggregate Functions
- Window Specification
- CSUM
- CUME_DIST
- DENSE_RANK (ANSI)
- FIRST_VALUE/LAST_VALUE
- LAG/LEAD
- MAVG
- MDIFF
- MEDIAN
- MLINREG
- MSUM
- PERCENT_RANK
- PERCENTILE_CONT/PERCENTILE_DISC
- QUANTILE
- RANK (ANSI)
- RANK (Teradata)
- ROW_NUMBER