select语句问题

[zly1980]

table1:ftype,fval,fgroup三个字段.
现在要select出的结果是:fgroup,type1sum,type2sum

fgroup-是分组字段,type1sum 是ftype=1的fval的和,type2sum是ftype=2的fval的和,ftype只有二个值:1,2
SELECT语句怎么写?

[VCLIFE]

真快

[mao5588]

不知道这样行不行 请指教 select fgroup from table
group by fgroup
group by fval

[EmeraldSword]

wgzaaa()写的这句有点意思！加上别名就更有意思了！

select fgroup
，sum(fval*(2-ftype)) type1sum
，sum(fval*(ftype-1)) type2sum
from #table1
group by fgroup

[david0927cs2006]

select fgroup,
sum(case ftype when 1 then fval else 0 end) as type1sum,
sum(case ftype when 2 then fval else 0 end) as type2sum
from table1
group by fgroup

[david0927cs2006]

呵呵,和前面的重复了

[sjlion]

顶楼上，创意不错

[chuifengde]

select
fgroup,
type1sum=sum(case when ftype=1 then fval else 0 end),
type2sum=sum(case when ftype=2 then fval else 0 end)
from table1
group by fgroup

[肥胖的柠檬]

select fgroup,(case when type=1 then fval else 0) type1sum,
(case when type=2 then fval else 0) type2sum
from table1
group by fgroup,fval

[肥胖的柠檬]

...怪自己打字慢..

[wgzaaa]

select fgroup,sum(case ftype when 1 then fval else 0 end)type1sum,
sum(case ftype when 2 then fval else 0 end)type2sum from table1

[Andy-W]

1楼正解，1楼速度真快

[wgzaaa]

我的有问题吗

[wgzaaa]

sorry group by fgroup

[wgzaaa]

为挽救自己再写一个
select fgroup,sum(fval*(2-ftype)),sum(fval*(ftype-1)) from #table1 group by fgroup