โ™ฅโ™ฅโ™ฅ
time 60
score 0
sql concept hard +300 base

What does ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) compute?

SELECT name, dept, salary,
  ROW_NUMBER() OVER (
    PARTITION BY dept
    ORDER BY salary DESC
  ) AS rank
FROM employees;
โ†’