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

Second Highest Distinct Salary

Return the second highest distinct salary, or NULL if there is none.

Table schema

Salaries(id INT PRIMARY KEY, salary INT)

Sample data

id | salary
1 | 100
2 | 200
3 | 200
4 | 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.