Expand description
Different frame clause specifications for window functions
Structsยง
- Current
Row - A
CURRENT ROWframe bound - Exclude
Current Row - Exclude the current row from the window frame
- Exclude
Group - Exclude the current peer group from the window frame
- Exclude
NoOthers - Exclude no rows from the frame windows
- Exclude
Ties - Exclude any peers, but not the current row from the window frame
- Groups
- Groups frame mode
- Range
- Range frame mode
- Rows
- Rows frame mode
- Unbounded
Following - A
UNBOUNDED FOLLOWINGframe bound - Unbounded
Preceding - A
UNBOUNDED PRECEDINGframe bound