题解 | #考试分数(五)#
考试分数(五)
https://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0512
select id,job,score,t_rank from (select *,row_number()over(partition by job order by score desc) as t_rank, count(1)over(partition by job) as n from grade) t1 where t_rank in ((n+1)/2,n/2+1,n/2) order by id asc;由于上一题我用的也是窗口函数，所以这一题更简单
