Skip to main content
Admissions guidance, study banks, and career tools — get started on Shalyam

Second Highest Salary

Medium Subqueries

Return the second highest distinct salary as a column named SecondHighestSalary. If there is no second highest salary, return NULL.

Table schema

Employee(id INT PRIMARY KEY, salary INT)

Sample data

id | salary
1 | 100
2 | 200
3 | 300

Discussion

No discussions yet.

Rewards · v2.1

Get Exclusive Insights with Every Issue

Join Shalyam Newsletter

Stay ahead in education, research, and innovation—straight to your inbox.