题解 | #最差是第几名(一)#
最差是第几名(一)
https://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
select grade ,(select sum(number) from class_grade t2 where t1.grade>=t2.grade) from class_grade t1 order by grade
子查询
最差是第几名(一)
https://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
select grade ,(select sum(number) from class_grade t2 where t1.grade>=t2.grade) from class_grade t1 order by grade
子查询
相关推荐