Top N Per Group with Window | Dataford Interview Questions

Write a SQL query using a window function to find the top three highest-paid employees in each department.

Use the employees and departments tables. Exclude employees without a department or salary, and break salary ties by the lower employee_id.

Output

One row per selected employee, with department_id, department_name, employee_id, employee_name, salary, and salary_rank.
Include up to three employees per department, ordered by department_id, then salary_rank.

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department name

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department_id	INT	Employee department identifier
salary	NUMERIC(12,2)	Annual employee salary

Your question is Top N Per Group with Window. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.