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