oracle 统计当月,按年累计sql求教(显示当月值，和累计值).....

--表中是我已经计算好的当月值，和按年累计值，由于数据比较多，所以表中的数据都已经是按月份聚合完的。下面是我的希望一条sql写出所有年的按月累计值，不过有问题，

请教一下大家，还有希望大家帮忙写个更好的。谢谢

我想要的结果就是 select * from test_leiji;

create table test_leiji(rpt_month_id number(8),

current_month NUMBER(12,2),

sum_month number(12,2));

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200901, 380128.344363, 380128.344363);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200902, 274474.595772, 654602.940135);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200903, 309427.898521, 964030.838656);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200904, 379854.833875, 1343885.672531);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200905, 359706.983914, 1703592.656445);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200906, 403766.051283, 2107358.707728);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200907, 453594.122698, 2560952.830426);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200908, 508901.559087, 3069854.389513);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200909, 540866.860072, 3610721.249585);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200910, 534240.768901, 4144962.018486);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200801, 400029.283054, 400029.283054);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200802, 325954.936035, 725984.219089);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200803, 286901.893385, 1012886.112474);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200804, 376893.587073, 1389779.699547);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200805, 384495.391046, 1774275.090593);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200806, 409538.637343, 2183813.727936);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200807, 424948.050578, 2608761.778514);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200808, 477254.081388, 3086015.859902);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200809, 488306.035893, 3574321.895795);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200810, 474617.235784, 4048939.131579);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200811, 422816.453183, 4471755.584762);

insert into test_leiji (RPT_MONTH_ID, CURRENT_MONTH, SUM_MONTH) values (200812, 267934.940893, 4739690.525655);

with rr as

(select tl.rpt_month_id,

sum(tl.current_month) current_month,

row_number() over(PARTITION by substr(tl.rpt_month_id, 1, 4) order by tl.rpt_month_id) rn

from test_leiji tl

group by tl.rpt_month_id)

select distinct aa1.rpt_month_id,

aa1.current_month,

sum(aa1.current_month) over (partition by substr(aa1.rpt_month_id,1,4) order by aa1.rn)

from rr aa1,rr aa2

where aa1.rn<=aa2.rn

and substr(aa1.rpt_month_id,1,4)=substr(aa2.rpt_month_id,1,4)