SQL SERVER中请问根据不同条件查询同一个表获得的不同数据集做减如何实现

select sum(count) from table1 where id=1 group by branch
select sum(count) from table1 where id=2 group by branch
将不同branch下的总数分别相减

select sum(case when id = 1 then count else 0 end) - sum(case when id = 2 then count else 0 end)
from table1
group by branch

如果是sql 2005以上的版本 可用xml类型参数把结果转xml格式传参结果集,