Top 5 Highest-Paid Employees | Dataford Interview Questions

List top 5 highest-paid employees.

Asked in the technical stage. This was a live SQL round using an Employees/Departments schema, with screen sharing and query output pasted into chat.

Output

Return five rows with rank_position, employee_name, salary, and department_name.
Include employees with non-null salaries, ordered from highest to lowest salary.
Break salary ties by ascending employee_id.

employees

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

departments

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

Your question is Top 5 Highest-Paid Employees. 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.