几个小问题请教，谢谢！

[ytnice]

1：
aa 1 1000
aa 2 2000
aa 3 1500
aa 4 1200
aa 5 800
...

实现
aa 1 1000 1000
aa 2 2000 3000
aa 3 1500 4500
aa 4 1200 5700
aa 5 800 6500
...

sql语句怎么写？

2：如何选出n条记录中第5大的数字。

[chd2001]

一条语句太难了把，写个存储过程拉

[yyhyy23]

select a.*,b.total from tablename a,(select sum(col3) as total from tablename ) b where a.col1=b.col2 and a.id<=b.id

[yyhyy23]

第二个问题用游标循环

[guanshiyu123]

select a.a,sum(b.b) from aa a ,aa b where a.a>=b.a group by a.a

[guanshiyu123]

测试数据
create table aa(a int,b int)
insert aa select 1 , 1000
union
select 2, 2000
union
select 3, 1500
union
select 4, 1200
union
select 5 , 800

所求语句

select a.a,sum(b.b) from aa a ,aa b where a.a>=b.a group by a.a

[guanshiyu123]

第二问
select min(b) from ( select top 5 * from aa order by b desc) f

[ytnice]

<tr>
<td>
aaa
</td>
</tr>

[colinliu]

select a.a,sum(b.b) from aa a ,aa b where a.a>=b.a group by a.a