Median Salary
Hard
Advanced Queries
Return the median salary of all employees. For an even number of employees the median is the average of the two middle values. Return a single column named median_salary.
Table schema
Employees(id INT PRIMARY KEY, salary INT)Sample data
id | salary
1 | 100
2 | 200
3 | 300
4 | 400
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.