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) t1
where a >= total/2 and b >=total/2
order by grade;
题目解答当某一数的正序和逆序的累计均大于等于整个序列的数字个数的一半即为中位数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) t1where a >