leetcode 569. 员工薪水中位数

garrulousabyss

于 2024-05-17 06:16:43 发布

阅读量105

点赞数 2

文章标签： leetcode mysql

本文链接：https://blog.csdn.net/garrulousabyss/article/details/138988241

版权

# Write your MySQL query statement below

# Write your MySQL query statement below
select id, company, salary
from 
(
    select Employee.*,
    row_number() over(partition by company order by salary) as rnk,
    count(company) over(partition by company) as n
    from Employee

) t
where rnk in (n/2, n/2+1, (n+1)/2)