SQL Ranking: 3rd Highest Salary | Dataford Interview Questions

AXA XL's Financial Planning and Analysis team needs a department-level view of salary bands. Write a PostgreSQL query using a window function to display employees earning the third-highest distinct salary within each department.

Requirements

Rank distinct non-null salaries independently within each department.
Return every employee tied at the third-highest salary.
Exclude employees without a department or salary, and exclude departments with fewer than three distinct salaries.
Sort the output by department and employee ID.

Schema

employees

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

Your question is SQL Ranking: 3rd Highest Salary. 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

Requirements

Rank distinct non-null salaries independently within each department.
Return every employee tied at the third-highest salary.
Exclude employees without a department or salary, and exclude departments with fewer than three distinct salaries.
Sort the output by department and employee ID.

Schema

employees

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

Your question is SQL Ranking: 3rd Highest Salary. 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.