重新求一段累计代码。

[ZXYSOSO]

CREATE TABLE [dbo].[Test] (
[a] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[b] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[c] [int] NULL
) ON [PRIMARY]

a b c
aaaa afdf 10
aaaa sgh 10
aaaa sghsh 30
bbbb dhjj 10
bbbb sghsh 10
... .... ...
内容按字段a分组
我要得到如下结果
a b c LJ
aaaa afdf 10 10
aaaa sgh 10 20
aaaa sghsh 30 50
bbbb dhjj 10 10
bbbb sghsh 10 20
... .... ... ...
要注意：
按字段a分组，字段b的值不是固定的,注意：这是我说的一个例子，值不是固定的不变的，通过这个例子希望大家明白我说的意思。

[liangpei2008]

CREATE TABLE [dbo].[Test] (
[a] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[b] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[c] [int] NULL
) ON [PRIMARY]
Insert test select 'aaaa','afdf',10
union all select 'aaaa','sgh',10
union all select 'aaaa','sghsh',30
union all select 'bbbb','dhjj',10
union all select 'bbbb','sghsh',10
--借用临时表，生成ID号
Select *,Identity(Int,1,1) as Id Into # From Test
--查询
Select *,
LJ=(Select Sum(C) From # Where T1.A=A And Id<=T1.ID)
From # T1

[LouisXIV]

select a,b,c,(select sum(c) from test where a=t.a and b<=t.b) as LJ
from test t

[xyxfly]

select id=identity(int,1,1),* into #T from test
select b.*, LJ=(select sum(c) from #T where id<=a.id and a=b.a) from #T b

[xyxfly]

晕,跟一楼好象,不过不是抄的啊,哈哈

[ZXYSOSO]

送分。