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.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.