select c1.grade from (select grade,sum(number)over(order by grade)-number+1 as first, sum(number)over(order by grade) as last from CLASS_GRADE)c1, -- 找到number对应的数字的首尾 (SELECT CASE WHEN SUM(NUMBER)%2=0 THEN SUM(NUMBER)/2 ELSE (SUM(NUMBER)+1)/2 END AS FIRST_mid, CASE WHEN SUM(NUMBER)%2=0 THEN SUM(NUM...
