题解 | #最差是第几名(二)#
最差是第几名(二)
http://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
(select grade
from (select grade,sum(number)over(order by grade) s1,
sum(number)over() / 2 m
from class_grade order by grade) a
where a.s1 >= a.m
limit 1)
union
(select grade
from (select grade,sum(number)over(order by grade desc) s2,
sum(number)over() / 2 m
from class_grade order by grade desc) b
where b.s2 >= b.m
limit 1);
曼迪匹艾公司福利 124人发布
