SQL Top Five Salaries | Dataford Interview Questions

Write an SQL query to retrieve the top five employees with the highest salaries from a database schema.

Use the employees table. Exclude employees whose salary is missing. If salaries are tied, order those employees by employee_id in ascending order.

Output

One row per selected employee.
Columns: employee_id, employee_name, and salary.
Return exactly five rows, ordered by salary from highest to lowest, then employee ID ascending for ties.

Schema

employees

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

Your question is SQL Top Five Salaries. Start with the requirements and the one table 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