题解 | #考试分数(五)#
考试分数(五)
https://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0513
select
id,
job,
score,
rk
from
(
select
id,
job,
score,
row_number() over (
partition by
job
order by
score desc
) rk,
count(job) over (
partition by
job
) n
from
grade
) t
where
rk in ((n + 1) / 2, n / 2, n / 2 + 1)
order by
id
查看23道真题和解析