Window Functions
2 / 22
EasyOutput prediction

PARTITION BY

Given this table (employees):

idnamedeptsalary
1AliceEng90000
2BobEng80000
3CarolHR70000
4DaveHR75000

What does this query return?

SELECT name, dept,
       ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) AS rn
FROM employees;

← → arrow keys to navigate

Sign in to save your progress.

PARTITION BY - SQL Window Functions Quiz | Unnested