What does PARTITION BY do in a window function?

Question

Accepted Answer

PARTITION BY is like GROUP BY for window functions, but the key difference is that rows are never collapsed. Every input row stays in the output - the window function just resets its calculation at each partition boundary. For example, RANK() OVER (PARTITION BY dept ORDER BY salary DESC) ranks employees within each department, not across the whole company.