题解 | #最差是第几名(一)#
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
题目挺花哨,其实就是用窗口函数求滚动sum
select grade, sum(number) over (order by grade) as t_rank
from class_grade
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
题目挺花哨,其实就是用窗口函数求滚动sum
select grade, sum(number) over (order by grade) as t_rank
from class_grade
相关推荐