题解 | #最差是第几名(一)#
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
解法1：直接求和
SELECT c.grade,(
SELECT SUM(d.number)
FROM class_grade AS d
WHERE d.grade<=c.grade
) AS t_rank
FROM class_grade AS c
ORDER BY c.grade
解法2：窗口函数
SELECT c.grade,SUM(c.number) OVER(ORDER BY c.grade) AS t_rank
FROM class_grade AS c
三七互娱公司福利 371人发布
查看9道真题和解析