Top 3 Highest Paid Employees | Dataford Interview Questions

Jio's workforce analytics team needs a simple report showing the three employees with the highest annual salaries. Write a PostgreSQL query using the employees table.

Requirements

Return the employee ID, employee name, and annual salary.
Sort employees from highest to lowest salary and return only the top three. Treat employees with NULL salaries as unranked, and use employee ID as a deterministic tie-breaker.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
annual_salary	DECIMAL(12,2)	Annual salary in Indian rupees
department	VARCHAR(80)	Employee's department

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

Jio's workforce analytics team needs a simple report showing the three employees with the highest annual salaries. Write a PostgreSQL query using the employees table.

Requirements

Return the employee ID, employee name, and annual salary.
Sort employees from highest to lowest salary and return only the top three. Treat employees with NULL salaries as unranked, and use employee ID as a deterministic tie-breaker.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
annual_salary	DECIMAL(12,2)	Annual salary in Indian rupees
department	VARCHAR(80)	Employee's department

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