题解 | #考试分数(五)#
考试分数(五)
https://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0512
#重点：寻找中位数，分成奇偶两种情况判断
select id,job,score,rk
from(
select id,job,score, count(id) over (partition by job) as c,dense_rank() over (partition by job order by score desc) as rk
from grade) as a
where (
case when a.c%2 = 1 then a.rk = (a.c+1)/2
else (a.rk = a.c/2+1 or a.rk = a.c/2) end
)
order by id asc
接