题解 | 最差是第几名(一)
最差是第几名(一)
https://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
select
t1.grade,
sum(t1.number) over(order by t1.grade asc rows between unbounded preceding and current row) as t_rank
from
(select *
from class_grade
order by grade) t1
我知道要实习了 人家大二都去实习了