題解 | #最差是第幾名(一)#
最差是第幾名(一)
http://www.fangfengwang8.cn/practice/ae5e8273e73b4413823b676081bd355c
SELECT grade, SUM(number) over(ORDER BY grade) "t_rank" FROM class_grade
#題意理解為:按照grade升序,累加排名即可
最差是第幾名(一)
http://www.fangfengwang8.cn/practice/ae5e8273e73b4413823b676081bd355c
SELECT grade, SUM(number) over(ORDER BY grade) "t_rank" FROM class_grade
相關(guān)推薦