题解 |求在sun(number)中位数上的grade
最差是第几名(二)
https://www.nowcoder.com/practice/165d88474d434597bcd2af8bf72b24f1
-- 并不需要提前求中位数, 计算一半就行 select grade from (select grade,(select sum(number) from class_grade) as total, sum(number) over (order by grade ) as a, sum(number) over (order by grade desc ) as b from class_grade) c where a>= total/2 and b>= total/2 order by grade;
