EasyOutput prediction
ROW_NUMBER basics
Given this table (employees):
| id | name | dept | salary |
|---|---|---|---|
| 1 | Alice | Eng | 90000 |
| 2 | Bob | Eng | 80000 |
| 3 | Carol | HR | 70000 |
What does this query return?
SELECT name, ROW_NUMBER() OVER (ORDER BY salary DESC) AS rn FROM employees;
← → arrow keys to navigate
Sign in to save your progress.