SQL Quest › SQL Interview Questions › Window Functions

Window Functions: ROW_NUMBER

MediumFreeQuerying BasicsWindow Functions

Window functions calculate values across rows without collapsing them (unlike GROUP BY). Add a row_num to each employee within their department, ordered by salary descending, then name for ties (highest paid = 1). Show name, department, salary, and row_num. Sort by department, row_num. This is the gateway to all window functions.

Solve it in the browser editor →

Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect".

Schema

employees

emp_id	name	department	position	salary	hire_date	manager_id	performance_rating
1	Alice Johnson	Engineering	Senior Developer	95000	2019-03-15	5	4.5
2	Bob Smith	Engineering	Developer	75000	2020-06-01	1	3.8
3	Carol Williams	Marketing	Marketing Manager	85000	2018-09-20	NULL	4.2

Expected output: Alice row_num=1, Bob row_num=2

Hint

ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC) AS row_num. PARTITION BY creates separate numbering per department. OVER() defines the window.

Concepts

SELECT Window Functions ROW_NUMBER

Practise the topic: SQL practice questions · Window function practice · Ranking function practice

In these company practice sets

Anthropic · OpenAI · Snowflake · Uber · Microsoft

A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.

Window Functions: ROW_NUMBER

Schema

Hint

Concepts

In these company practice sets

Related questions