this ?
declare @t1 table
(
amount int,
class char(1)
)
insert into @t1
select 100, 'A' union all
select 200, 'B' union all
select 230, 'C' union all
select 233, 'A' union all
select 400, 'E'
select sum(case when class = 'A' then amount else 0 end) as [Sum of A],
sum(case when class <> 'A' then amount else 0 end) as [Sum of Others]
from @t1
/*
Sum of A Sum of Others
----------- -------------
333 830
*/
KH
one group vs others
Posted - 01/29/2007 : 16:00:35
