用子查询也可以 select grade ,(select sum(number) from class_grade as t2 where t1.grade >= t2.grade) as t_rank from class_grade as t1 order by grade
点赞

相关推荐

不愿透露姓名的神秘牛友
11-26 15:46
已编辑
字节国际 电商后端 24k-35k
点赞 评论 收藏
分享
牛客网
牛客企业服务