Second-Highest Salary Without LIMIT | Dataford Interview Questions

Persistent Systems wants to identify the second-highest distinct salary in its engineering workforce. Write a PostgreSQL query using the employees table, without using the LIMIT keyword.

Requirements

Return the second-highest distinct non-NULL salary as second_highest_salary.
Handle duplicate salaries correctly. If multiple employees share the highest salary, the next lower distinct salary is still the answer.
Return NULL if there is no salary below the maximum salary.
Do not use LIMIT.

Schema

employees

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

Your question is Second-Highest Salary Without LIMIT. 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

Persistent Systems wants to identify the second-highest distinct salary in its engineering workforce. Write a PostgreSQL query using the employees table, without using the LIMIT keyword.

Requirements

Return the second-highest distinct non-NULL salary as second_highest_salary.
Handle duplicate salaries correctly. If multiple employees share the highest salary, the next lower distinct salary is still the answer.
Return NULL if there is no salary below the maximum salary.
Do not use LIMIT.

Schema

employees

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

Your question is Second-Highest Salary Without LIMIT. 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.