怎样不用游标实现这样的统计

[lqe_ada]

A B C 出货 进货 style

a b c 10 1
a b c 1 -1
a b d 10 1
a b e 1 1

A,B,C 组成主键,现在要求如下的结果(不用游标)。。。。

A B C 出货 进货 实际出货

a b c 10 1 9
a b d 10 10
a b e 1 -1

[lqe_ada]

对不起，写错了。正确的应该如下：
A B C 出货 进货 style

a b c 10 1
a b c 1 -1
a b d 10 1
a b e 1 -1

A,B,C 组成主键,现在要求如下的结果。。。。

A B C 出货 进货 实际出货

a b c 10 1 9
a b d 10 10
a b e 1 -1

[愉快的登山者]

select A,B,C,
sum(isnull(出货,0)) 出货,
sum(isnull(进货,0)) 进货,
sum(isnull(出货,0) - isnull(进货,0)) 实际出货 from table1
group by A,B,C

[arrow_gx]

select A,B,C,sum(出货),sum(进货),sum(出货)-sum(进货) as 实际出货 from yourtable

group by a,b,c

[samuelpan]

select A,B,C,
Case When Style=1 Then Sum(IsNull(出货,0)) End As 出货，
Case When Style=-1 Then Sum(IsNull(进货,0)) End As 进货，
Sum(IsNull(出货,0))-Sum(IsNull(进货,0)) As 实际出货
from table
group by a,b,c

[yujohny]

select A,B,C,sum(出货) as 出货,sum(进货) as 进货,
sum(出货*style)+sum(进货*style) as 实际进货
from 表 group by A,B,C

[welyngj]

create table aa
( a char,
b char,
c char,
ex int,
im int,
style int)
insert into aa select 'a','b','c',10,null,1
insert into aa select 'a','b','c',null,1,-1
insert into aa select 'a','b','d',10,null,1
insert into aa select 'a','b','e',null,1,-1


select a,b,c,max(ex) as ex ,max(im) im ,sum(isnull(ex,0))-sum(isnull(im,0)) from aa group by a,b,c

[Dennis618]

select a,b,c,sum(出货) as 出货,sum(进货) as 进货,isnull(sum(出货),0)-isnull(sum(进货),0) as 实际出货 from table3 group by a,b,c

[orcale]

select a,b,c,sum(出貨) as 出貨,sum(進貨) as 進貨,(sum(出貨)-sum(進貨))
as 實際出貨 from table group by a,b,c

[Frewin]

select A,B,C,sum(出货) as 出货,sum(进货) as 进货,
sum(出货*style)+sum(进货*style) as 实际进货
from 表 group by A,B,C

[txlicenhe]

select A,B,C,sum(出货) as 出货,sum(IsNull(进货,0)) as 进货,
sum(IsNull(出货,0)*style)+sum(IsNull(进货,0)*style) as 实际进货
from 表 group by A,B,C

[wzh1215]

select A,B,C,sum(isnull(出货,0)) 出货,sum(isnull(进货,0)) 进货,
sum(isnull(出货,0) - isnull(进货,0)) 实际出货 from table1
group by A,B,C