题解 | #考试分数(五)#
考试分数(五)
http://www.nowcoder.com/practice/b626ff9e2ad04789954c2132c74c0512
select id,job,score,t_rank
from (select ,row_number()over(partition by job order by score desc) t_rank,
count()over(partition by job) n
from grade) a
where t_rank >= n/2 and t_rank <= (n/2+1)
order by id;
查看14道真题和解析
