SQL: Second and Nth Highest Salary | Dataford Interview Questions

Write a query to select an employee with the second highest salary, and then write a query for the nth highest salary.

For this exercise, use n = 4 for the sample evaluation. Include all employees tied at either requested salary level and ignore employees whose salary is NULL.

Output

One row per employee with the second or fourth highest distinct salary.
Columns: employee_id, employee_name, salary, and salary_rank.
Order by salary_rank ascending, salary descending, then employee_id ascending.

Schema

employees

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

Your question is SQL: Second and Nth Highest Salary. 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