求汇总Sql 在线等

[zhangyang555]

表结构如下:

Type Parent ChildType Number
2 6 2 500
2 6 1 600
1 3 1 300
1 3 1 500
1 3 2 100
3 1 1 100
3 1 2 100
3 1 2 900

ChildType 取值为1和2

需得以下汇总结果(根据ChildType的值对Number求和)：
Type Parent SumChildType1 SumChildType2
1 3 800 100
2 6 600 500
3 1 100 1000

[WangZWang]

select Type,Parent,
sumChildType1=sum(case when ChildType=1 then Number else 0 end),
sumChildType2=sum(case when ChildType=2 then Number else 0 end)
from table
group by Type,Parent
order by type

[xeqtr1982]

create table tb(Type int,Parent int,ChildType int,Number int)
insert into tb select 2,6,2,500
union all select 2,6,1,600
union all select 1,3,1,300
union all select 1,3,1,500
union all select 1,3,2,100
union all select 3,1,1,100
union all select 3,1,2,100
union all select 3,1,2,900

declare @sql varchar(8000)
set @sql='select Type,Parent'
select @sql=@sql+',[SumChildType'+cast(ChildType as varchar)+']=sum(case ChildType when '+cast(ChildType as varchar)+' then Number else 0 end)' from tb group by ChildType
exec(@sql+' from tb group by Type,Parent order by Type')

drop table tb

[子陌红尘]

select
Type,
Parent,
SumChildType1=sum(case ChildType when 1 then Number else 0 end),
SumChildType2=sum(case ChildType when 2 then Number else 0 end)
from
表
group by
Type,Parent

[zhangyang555]

兄弟可以留个联系方式不,QQ/MSN都可以,以后有问题我就直接把帖子的地址发给你