题解 | #最差是第几名(一)#
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
select
a.grade
,sum(a.number) over (order by grade)
from (
select
*
from class_grade
order by grade
) a
最差是第几名(一)
http://www.nowcoder.com/practice/ae5e8273e73b4413823b676081bd355c
select
a.grade
,sum(a.number) over (order by grade)
from (
select
*
from class_grade
order by grade
) a
相关推荐