题解 | #最差是第几名(一)#
最差是第几名(一)
https://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
select grade, (select sum(number) from class_grade c2 where c1.grade >= c2.grade ) from class_grade c1 order by grade asc
经典模板题目，要注意的是：row_number(), rank, dense_rank，一般与over(order by xxx)连用