sql问题（请教)

[yangq4000]

表: TA
字段:
FA,Status
001,0
002,1
001,0
001,0
001,1
002,0
...
Select FA, Count(*) as Qty from TA where Status = 0 group By FA
Select FA, Count(*) as Qty from TA where Status = 1 group By FA

我想合并以上两个查询，类似以下，如何写
Select FA, （Status =0 的记录数减去 Status =1的记录数） as Qty from TA group By FA

[victorycyz]

select FA, sum(1-status*2) as qty from TA group by FA

[wzh1215]

楼上的方法不错！

[dafu71]

Select FA, sum(case when Status =0 then 1 else -1 end） as Qty from TA group By FA