逻辑游戏
select grade from (select grade,sum(number)over() as t,sum(number) over(order by grade) as p,number from class_grade)r1 where IF(t%2=1,p>=(t+1)/2 and p-number<(t+1)/2,p>=t/2 and p-number<t/2 or p>=t/2+1 and p-number<t/2+1)
逻辑游戏
select grade from (select grade,sum(number)over() as t,sum(number) over(order by grade) as p,number from class_grade)r1 where IF(t%2=1,p>=(t+1)/2 and p-number<(t+1)/2,p>=t/2 and p-number<t/2 or p>=t/2+1 and p-number<t/2+1)
牛客博客，记录你的成长
京公网安备 11010502036488号