select grade, sum(number) over(order by grade) t_rank
from class_grade
  • 使用窗口函数得到累加值