RANGE

0001-01-01

Frame Semantics: ROWS, RANGE, and GROUPS

A window frame defines exactly which rows each window function sees. ROWS counts positions, RANGE counts values, GROUPS counts distinct peers. Mixing them up produces silent bugs.