Nth Salary SQL

00:00

5 left

Nth Salary SQL

MediumSQL · PostgreSQL

Problem

Write a SQL query to find the nth salary.

Treat salaries as distinct values, ignore NULL salaries, and use n = 3 for this exercise.

Output

Return one row with one column named nth_salary.
Return the third-highest distinct non-NULL salary.

Schema

employees

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

Tablesemployees

CodePostgreSQL

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

Run your query to see results here.