题解 | 考试分数(五)
考试分数(五)
https://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0513
select id,job,score,rank2 from (select *,dense_rank()over(partition by job order by score) rank1,dense_rank()over(partition by job order by score desc) rank2,count(id)over(partition by job) count1 from grade) as t1 where rank1 >= count1/2 and rank2 >= count1/2 order by id
记得有道题和这个类似，借鉴了下那道题评论区的思路，有点投机取巧？
投递字节跳动等公司8个岗位