PARTITION BY: does the counter reset per group?

Question

Accepted Answer

PARTITION BY dept resets the row number counter for each department. Within Eng, Alice (90000) gets 1, Bob (80000) gets 2. Within HR, Dave (75000) gets 1, Carol (70000) gets 2. PARTITION BY is like GROUP BY for window functions - it defines independent windows, one per partition value.