oracle 下一行,oracle sql 怎么實現 下一行的數值等於上一行總和加這一行的值

有表 t1， 字段 n1 varchar(20), n2 numeric

表內數據

a 20.5

b 30

希望得到以下這樣的結果(第三列的值 = 本行字段n2的值 + 前一行第三列的值)

a 20.5 20.5

b 30 50.5

sql怎么寫？

select a.rn, a.id, a.value + case when ((select sum(value) from aaa a2 where  rownum <= a.rn -1  ) <> 0) or ((select sum(value) from aaa a2 where  rownum <= a.rn -1  ) is not null) then (select sum(value) from aaa a2 where  rownum <= a.rn -1  )

else 0 end

from

(

select rownum rn, id, value  from aaa

)a

數據

insert into aaa (ID, VALUE, ROWID)

values ('a', 10.000000000, 'AABVdjAABAAAjWyAAA');

insert into aaa (ID, VALUE, ROWID)

values ('b', 15.000000000, 'AABVdjAABAAAjWyAAB');

insert into aaa (ID, VALUE, ROWID)

values ('c', 20.000000000, 'AABVdjAABAAAjWyAAC');

insert into aaa (ID, VALUE, ROWID)

values ('d', 25.000000000, 'AABVdjAABAAAjWyAAD');

表

CREATE TABLE "AAA"

( "ID" VARCHAR2(36) NOT NULL ENABLE,

"VALUE" NUMBER(18,9)

)