34,837
社区成员




create table tb(id int, name varchar(10), val int, [month] int )
insert into tb values(101, 'aaa', 100.00 , 0 )
insert into tb values(102, 'bbb', 555.00 , 0 )
insert into tb values(103, 'bbb', 700.00 , 1 )
insert into tb values(104, 'ddd', 895.00 , 1 )
insert into tb values(105, 'eee', 700.00 , 0 )
insert into tb values(106, 'aaa', 800.00 , 1 )
go
select name ,
sum(case [month] when 1 then val else 0 end) val,
sum(case [month] when 0 then val else 0 end) val_1
from tb
group by name
drop table tb
/*
name val val_1
---------- ----------- -----------
aaa 800 100
bbb 700 555
ddd 895 0
eee 0 700
(所影响的行数为 4 行)
*/