Window Functions
Window Functions are special functions where the result is dependent on the order and grouping of rows.
- CumeDist
- CumulativeAvg
- CumulativeCorr
- CumulativeCount
- CumulativeMax
- CumulativeMin
- CumulativeStdDev
- CumulativeSum
- CumulativeVariance
- FillDown
- First
- Lag
- Last
- Lead
- ListAgg
- MovingAvg
- MovingCorr
- MovingCount
- MovingMax
- MovingMin
- MovingStdDev
- MovingSum
- MovingVariance
- Nth
- Ntile
- Rank
- RankDense
- RankPercentile
- RowNumber
- Window Function Overview