Window Frame: ROWS vs RANGE vs GROUPS
Window Frame: ROWS vs RANGE vs GROUPS is a SQL function in the Window Functions category. Three window frame types: ROWS (physical rows), RANGE (peers based on ORDER BY), GROUPS (peer groups). The syntax is ROWS BETWEEN ... / RANGE BETWEEN ... / GROUPS BETWEEN .... It accepts see syntax. It returns window frame comparison. A typical example: SELECT name, salary, SUM(salary) OVER ( ORDER BY salary ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING ) AS rows_sum, SUM(salary) OVER ( ORDER BY salary RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING ) AS range_sum, SUM(salary) OVER ( ORDER BY salary GROUPS BETWEEN 1 PRECEDING AND 1 FOLLOWING ) AS groups_sum FROM employees; -- ROWS: exactly 3 rows (prev + current + next) -- RANGE: all rows with salary within… A close relative is ROW_NUMBER(), which assigns a unique sequential integer to each row within its partition (1, 2, 3...).