Second Largest Salary in SQL | Dataford Interview Questions

Afiniti needs a simple salary audit for employees supporting its AI-powered customer interaction platform. Write a PostgreSQL query to find the second-highest distinct salary in the employee directory.

Requirements

Exclude employees whose salary is NULL.
Return exactly one value: the second-highest distinct salary.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's name
department	VARCHAR(50)	Employee's department
salary	NUMERIC(10,2)	Annual salary

Your question is Second Largest Salary in SQL. 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

Exclude employees whose salary is NULL.
Return exactly one value: the second-highest distinct salary.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's name
department	VARCHAR(50)	Employee's department
salary	NUMERIC(10,2)	Annual salary

Your question is Second Largest Salary in SQL. 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.