题解 | #最差是第几名(一)#
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
窗口函数的应用
根据题意，对number按照grade累加
sum(number)over(order by grade)
这就是t_rank
所以结果为
select grade, sum(number) over(order by grade) t_rank from class_grade order by grade