题解 | #最差是第几名(一)#
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
当聚合函数+窗口函数+order by 可以实现滚动求和的目标
```select grade,sum(number)over(order by grade ) as t_tank
from class_grade
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
当聚合函数+窗口函数+order by 可以实现滚动求和的目标
```select grade,sum(number)over(order by grade ) as t_tank
from class_grade
相关推荐