Finding Second-Highest Values

MediumSQL · PostgreSQL

Problem

How would you identify the second-highest salary in a table using a subquery or window function?

Use the employees table and treat duplicate salaries as one salary level. Ignore NULL salaries and return the second-highest distinct salary, if one exists.

Output

Return one row with the column second_highest_salary.
Return no rows if fewer than two distinct non-NULL salaries exist.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
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.