SQL Query for Second Highest

EasySQL · PostgreSQL

Problem

Iris software wants a quick compensation report showing the second-highest salary currently recorded in its employee table. Write a PostgreSQL query that returns the second-highest distinct non-null salary.

Requirements

Ignore employees whose salary is NULL.
Treat duplicate salary values as one value, then return the second-highest salary in descending order.

Schema

employees

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