SQL Ranking: 3rd Highest Salary

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL Ranking: 3rd Highest Salary. Start with the requirements and the one table on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

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

Tablesemployees

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results