SQL Query for Second Highest | Dataford Interview Questions

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

Your question is SQL Query for Second Highest. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

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

Your question is SQL Query for Second Highest. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.