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

Nth Highest Salary

Medium Subqueries

Return the 3rd highest distinct salary as a column named third_highest, or NULL if there are fewer than three distinct salaries.

Table schema

Employees(id INT PRIMARY KEY, salary INT)

Sample data

id | salary
1 | 100
2 | 200
3 | 300
4 | 300
5 | 400

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.