急 求一sql语句 !

[ericlin]

表字段如下：
a b c
A B 0
A1 B1 0
A2 B2 0
A3 B3 0
.. .. ..
A B 1
A3 B4 1
.. .. ..
c字段为一标志
需要 sql 语句得到如下结果：
c字段为0的所有a总数 与 c字段为1的所有a总数之差
请大家指点

[pisces007]

select (select count(*) from yourtable where c=0)-
(select count(*) from yourtable where c=1)

[viptiger]

declare @a int
declare @b int

select @a = count(*) from tb
where c = 0

select @b = count(*) from tb
where c = 1

print @a - @b

[chengangcsdn]

up!

[ericlin]

SELECT T1.a, ..,
(SELECT COUNT(c)
FROM Table
WHERE c = 0 AND a = T1.a) -
(SELECT COUNT(c)
FROM Table
WHERE c = 1 AND a = T1.a) AS Expr1
FROM Table1 T INNER JOIN
Table T1 ON T.a = T1.a
GROUP BY T1.a, ...
行了
昨天不小心看错了 呵呵谢谢各位了