Second Highest Value SQL

EasySQL · PostgreSQL

Problem

Write a query to find the second highest value in a specific column.

Use employee_compensation.annual_salary as the target column and treat duplicate salary values as one distinct value. Return NULL if fewer than two distinct non-NULL salary values exist.

Output

Return one row with one column named second_highest_salary.
Return the second distinct highest value from annual_salary.

Schema

employee_compensation

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
annual_salary	DECIMAL(12,2)	Annual salary amount

Tablesemployee_compensation

CodePostgreSQL

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

Run your query to see results here.