select a.year, (select sum(fee) from test b where b.year <= a.year)
from test a
create table test(
year varchar(8),
fee number(8)
)
select *from test
insert into test values('2000',1000)
insert into test values('2001',2000);
insert into test values('2002',3000);
insert into test values('2003',4000);
from test a
create table test(
year varchar(8),
fee number(8)
)
select *from test
insert into test values('2000',1000)
insert into test values('2001',2000);
insert into test values('2002',3000);
insert into test values('2003',4000);