中位数题型 | #考试分数(五)#
考试分数(五)
https://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0513
select id, job, score, r from (select *, row_number() over (partition by job order by score desc) r, count(score) over (partition by job) s from grade) t where abs(r-(s+1)/2) < 1 order by id;
中位数题型总结，有空再开坑。
投递百度等公司7个岗位