题解 | #最差是第几名(一)#
最差是第几名(一)
https://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
select grade, sum(number) over(order by grade) t_rank from class_grade
- 使用窗口函数得到累加值
最差是第几名(一)
https://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
select grade, sum(number) over(order by grade) t_rank from class_grade
相关推荐