Second Highest Salary at NovaTech

EasySQL · PostgreSQL

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

Tablesemployees

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.