题解 | #最差是第几名(一)#
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
SELECT grade, SUM(number) over(ORDER BY grade) "t_rank" FROM class_grade
#题意理解为:按照grade升序,累加排名即可
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
SELECT grade, SUM(number) over(ORDER BY grade) "t_rank" FROM class_grade
相关推荐