Finding Second-Highest Values | Dataford Interview Questions

How would you identify the second-highest salary in a table using a subquery or window function?

Use the employees table and treat duplicate salaries as one salary level. Ignore NULL salaries and return the second-highest distinct salary, if one exists.

Output

Return one row with the column second_highest_salary.
Return no rows if fewer than two distinct non-NULL salaries exist.

Schema

employees

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

Your question is Finding Second-Highest Values. 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