ROWS vs RANGE frame modes

Question

Accepted Answer

With ROWS, '1 PRECEDING' means exactly the one row immediately before the current row in physical order - duplicates are treated separately. With RANGE, '1 PRECEDING' means all rows whose ORDER BY value falls within 1 unit of the current row's value - peers with the same value are all included together. This distinction matters most when you have ties. The default frame (RANGE UNBOUNDED PRECEDING AND CURRENT ROW) groups all ties with the current row, which is why running totals can look 'jumpy' when duplicates exist.