create table b
(
Years int,
Salaty int
)
insert into b values(2000,1000)
insert into b values(2001,2000)
insert into b values(2002,3000)
insert into b values(2003,4000)
select * from b
go
select Years, (select sum(Salaty) from b where b.Years<= c.Years) Salaty from b c
原文：http://www.cnblogs.com/gsh0921/p/6647251.html