Top 3 Salaries SQL Query | Dataford Interview Questions

PlayStation Network wants a simple compensation report showing its three highest-paid employees. Write a PostgreSQL query that retrieves the employee details for the highest salaries.

Requirements

Return employee_id, employee_name, and salary for the three highest non-null salaries.
Sort salaries from highest to lowest. Use employee_id as a secondary sort key for deterministic results when salaries are equal.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
salary	NUMERIC(12,2)	Annual salary in USD

Your question is Top 3 Salaries SQL Query. 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

PlayStation Network wants a simple compensation report showing its three highest-paid employees. Write a PostgreSQL query that retrieves the employee details for the highest salaries.

Requirements

Return employee_id, employee_name, and salary for the three highest non-null salaries.
Sort salaries from highest to lowest. Use employee_id as a secondary sort key for deterministic results when salaries are equal.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
salary	NUMERIC(12,2)	Annual salary in USD

Your question is Top 3 Salaries SQL Query. 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.