SQL: Second and Nth Highest Salary

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL: Second and Nth 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

Write a query to select an employee with the second highest salary, and then write a query for the nth highest salary.

For this exercise, use n = 4 for the sample evaluation. Include all employees tied at either requested salary level and ignore employees whose salary is NULL.

Output

One row per employee with the second or fourth highest distinct salary.
Columns: employee_id, employee_name, salary, and salary_rank.
Order by salary_rank ascending, salary descending, then employee_id ascending.

Schema

employees

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

Tablesemployees

Your solutionPostgreSQL

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

Run a query to see results