SQL Query for Third Largest

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL Query for Third Largest. Start with the requirements and the two tables 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

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

Tablesemployeesemployee_compensation

Your solutionPostgreSQL

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

Run a query to see results