SQL Top 10 Highest Paid | Dataford Interview Questions

Write a SQL query to find the top 10 highest-paid employees in a database.

Use the employee and department data available in the schema. Exclude employees without a salary and retain employees whose department does not have a matching record.

Output

One row per employee, with employee_id, employee_name, salary, and department_name
Return the 10 highest salaries first; break salary ties by ascending employee_id

Schema

employees

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

departments

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

Your question is SQL Top 10 Highest Paid. 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.

Problem