题解 | #网易云音乐推荐(网易校招笔试真题)#
最差是第几名(二)
http://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
select grade
from
(select grade
,(select sum(number) from class_grade) as 'total'
,sum(number) over(order by grade) a
,sum(number) over(order by grade desc) b
from class_grade) hh
where a>=total/2 and b>=total/2
order BY grade
from
(select grade
,(select sum(number) from class_grade) as 'total'
,sum(number) over(order by grade) a
,sum(number) over(order by grade desc) b
from class_grade) hh
where a>=total/2 and b>=total/2
order BY grade
查看16道真题和解析
