题解 | 考试分数(五)
考试分数(五)
https://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0513
select id, job, score, t_rank from ( select id, job, score, count(*) over(partition by job) as cnt, row_number() over(partition by job order by score desc) as t_rank from grade ) a where t_rank = FLOOR((cnt + 1) / 2) or t_rank = CEIL((cnt + 1) / 2) order by id ;
怪不得普通人连面试的机会都没有 笑了