Top Nth Salary Without LIMIT | Dataford Interview Questions

Write a query to find the Nth highest salary in a table without using LIMIT.

The runnable example uses N = 3. Treat salaries with the same value as one salary rank, exclude NULL salaries, and adjust the N value when needed.

Output

salaries

Column	Type	Description
salary_idPK	INTEGER	Unique salary record identifier
employee_name	VARCHAR(100)	Employee name associated with the salary
salary	NUMERIC(12,2)	Employee salary amount

Your question is Top Nth 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.

Write a query to find the Nth highest salary in a table without using LIMIT.

The runnable example uses N = 3. Treat salaries with the same value as one salary rank, exclude NULL salaries, and adjust the N value when needed.

salaries

Column	Type	Description
salary_idPK	INTEGER	Unique salary record identifier
employee_name	VARCHAR(100)	Employee name associated with the salary
salary	NUMERIC(12,2)	Employee salary amount

Your question is Top Nth 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.