题解 | #最差是第几名(一)#
最差是第几名(一)
https://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
SELECT grade
,MAX(t_rank) AS t_rank
FROM
(SELECT *
,SUM(NUMBER) OVER(ORDER BY grade ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS t_rank
FROM class_grade
) AS t1
GROUP BY grade