Cumulative |
- ROWS UNBOUNDED PRECEDING
- ROWS BETWEEN UNBOUNDED PRECEDING AND value PRECEDING
- ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
- ROWS BETWEEN UNBOUNDED PRECEDING AND value FOLLOWING
|
Group |
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING |
Moving |
- ROWS value PRECEDING
- ROWS CURRENT ROW
- ROWS BETWEEN value PRECEDING AND value PRECEDING
- ROWS BETWEEN value PRECEDING AND CURRENT ROW
- ROWS BETWEEN value PRECEDING AND value FOLLOWING
- ROWS BETWEEN CURRENT ROW AND CURRENT ROW
- ROWS BETWEEN CURRENT ROW AND value FOLLOWING
- ROWS BETWEEN value FOLLOWING AND value FOLLOWING
|
Remaining |
- ROWS BETWEEN value PRECEDING AND UNBOUNDED FOLLOWING
- ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING
- ROWS BETWEEN value FOLLOWING AND UNBOUNDED FOLLOWING
|