SELECT Id,
Company,
Salary
FROM
(SELECT Id,
Company,
Salary,
ROW_NUMBER() OVER(PARTITION BY Company ORDER BY Salary) AS rk,
COUNT(Salary) OVER(PARTITION BY Company) AS cnt
FROM Employee) a
WHERE rk BETWEEN cnt/2 AND cnt/2 + 1
SELECT Id,
Company,
Salary
FROM
(SELECT Id,
Company,
Salary,
ROW_NUMBER() OVER(PARTITION BY Company ORDER BY Salary) AS rk,
COUNT(Salary) OVER(PARTITION BY Company) AS cnt
FROM Employee) a
WHERE rk BETWEEN cnt/2 AND cnt/2 + 1