SQL Query for Third Largest | Dataford Interview Questions

Sun Life Financial's QA team needs to validate salary-ranking logic in an employee reporting query. Write a PostgreSQL query that identifies employees earning the third-highest distinct salary among active employees with recorded compensation.

Requirements

Join employees to employee_compensation using employee_id.
Exclude inactive employees and rows where salary is NULL.
Rank distinct salary values from highest to lowest and return every employee tied at rank 3.
Order the results by salary descending and employee ID ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
employment_status	VARCHAR(20)	Current employment status
department	VARCHAR(50)	Employee department

employee_compensation

Column	Type	Description
compensation_idPK	INT	Unique compensation record identifier
employee_id	INT	Employee receiving the compensation
salary	NUMERIC(12,2)	Annual base salary

Your question is SQL Query for Third Largest. 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