求一SQL语句

[xyqiqi]

原表字段
cardcode nowmoney
01 20
01 3.5
01 5
02 0
02 4
03 6
现想得到
cardcode mowmoney moneycount
01 20 20
01 3.5 23.5
01 5 28.5
02 0 0
02 4 4
03 6 6

[昵称被占用了]

select cardcode,nowmoney,IDENTITY(int,1,1) as id
into #
from 原表

select cardcode,nowmoney,
(select sum(nowmoney) from # where cardcode=a.cardcode and id<=a.id) as moneycount
from # a

drop table #

[paoluo]

如果順序不重要，且mowmoney沒有重復的話，可以不用臨時表，否則就要用到臨時表
Select
cardcode,
mowmoney,
(Select SUM(mowmoney) From TableName Where cardcode=A.cardcode And mowmoney<=A.mowmoney) As moneycount
From TableName A

[冷箫轻笛]

原表应该有ID一类的东西吧！？

[lxzm1001]

没有ID真的是有点不好办

[lxzm1001]

create table a(cardcode varchar(10),nowmoney money)
insert a select '01',20
union all select '01',3.5
union all select '01',5
union all select '02',0
union all select '02',4
union all select '03',6
select id=identity(int),* into b from a
select *,moneycount=(select sum(nowmoney) from b where cardcode=t.cardcode and id<=t.id) from b t

[FCU]

支持