PARTITION BY t.月份,t.类别 ORDER BY t.月份,t.类别
把你里面的id去掉。。。
select
t2.月份,
t2.类别,
round(sum(t2.revenue) OVER( PARTITION BY t2.类别 ORDER BY t2.类别,t2.month_number) ,2) as amount_s
from (select t.月份,t.类别,t.revenue,replace(t.月份,'月','')*1 as month_number from revenue t) t2