Second Highest Salary at NovaTech | Dataford Interview Questions

NovaTech wants a quick salary check from its employee records. Write a SQL query to return the second highest distinct salary from the employees table.

Requirements

Return exactly one column named second_highest_salary
Treat duplicate salaries as the same salary value
If a second highest salary does not exist, return NULL

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department	VARCHAR(50)	Employee department
salary	INT	Employee salary amount

Your question is Second Highest Salary at NovaTech. 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

NovaTech wants a quick salary check from its employee records. Write a SQL query to return the second highest distinct salary from the employees table.

Requirements

Return exactly one column named second_highest_salary
Treat duplicate salaries as the same salary value
If a second highest salary does not exist, return NULL

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
department	VARCHAR(50)	Employee department
salary	INT	Employee salary amount

Your question is Second Highest Salary at NovaTech. 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.