SQL 计算Median Number的快速方法

Write a SQL query to find the median salary of each company.

1. SELECT Id,Company,Salary
   
2. FROM (
   
3. SELECT
   
4. Id,Company,Salary,
   
5. ROW_NUMBER() OVER(PARTITION BY Company ORDER BY Salary) AS RN,
   
6. COUNT(Id) OVER(PARTITION BY Company) AS COUNTS
   
7. FROM Employee ) T
   
8. WHERE RN BETWEEN COUNTS/2.0 AND COUNTS/2.0 + 1
   
9. ORDER BY 2,3 ASC

复制代码