SQL Top Salary Query | Dataford Interview Questions

Ness Digital Engineering needs a salary review query for its employee reporting system. Write a PostgreSQL query that identifies every employee whose salary is the third-highest distinct salary in the salary table.

Requirements

Rank distinct salary amounts from highest to lowest using a window function.
Return all employees tied at the third-highest salary, not just one employee.
Join the ranked salary records to employees and return employee details with the salary.
Sort the final results by employee_id.
Ignore salary records whose salary_amount is NULL; they must not take part in the ranking.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
full_name	VARCHAR(100)	Employee full name
department	VARCHAR(80)	Ness department
job_title	VARCHAR(100)	Employee job title

salary

Column	Type	Description
salary_idPK	INT	Unique salary record identifier
employee_id	INT	Employee identifier associated with the salary record
salary_amount	NUMERIC(12,2)	Employee salary amount

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