Second Highest Salary | Dataford Interview Questions

Find the second highest salary.

Asked in the Virtual Onsite stage. SQL question testing window functions or aggregated ranking techniques.

Task

Write a PostgreSQL query that returns the second highest distinct salary from the employees table.

employees

Column	Type	Description
employee_idPK	INT	Primary key for each employee
employee_name	VARCHAR(100)	Employee name
salary	NUMERIC(12,2)	Employee salary

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

Find the second highest salary.

Asked in the Virtual Onsite stage. SQL question testing window functions or aggregated ranking techniques.

Write a PostgreSQL query that returns the second highest distinct salary from the employees table.

employees

Column	Type	Description
employee_idPK	INT	Primary key for each employee
employee_name	VARCHAR(100)	Employee name
salary	NUMERIC(12,2)	Employee salary

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