How does SUM(x) OVER (...) differ from SUM(x) with GROUP BY?
- It ignores NULL values
- It runs before
WHERE - It keeps every input row
- It only works on numbers
A window function computes across related rows but returns a value on each row instead of collapsing them.
Play SQL & Databases ▸