高手请进：求SQL语句！！！

[flyfishcn]

如何对同一个表的两个字段同时分组？？
希望结果集是：table.a,count(table.b),count(table.c)三个字段，请问SQL语句怎么写？？
请高手帮忙！！！

[lingco]

哦，以为是不同表

[lingco]

count (case when c is not null then c else end)

[wenchanyee]

统计出c中不为空的记录数 select count(c) from table where not c is null

[flyfishcn]

如何对同一个表的两个字段同时分组？？
table如：
a b c
001 1001 t
001 1002 f
002 1003
002 1004 t
002 1005 t
003 1006 　

希望结果集是：table.a,count(table.b),count(table.c<>'')三个字段，
请问SQL语句怎么写？？

这次问题说清楚了吧？请高手帮忙！！！

[flyfishcn]

补充：
希望结果集是：
001 2 2
002 3 2
003 1 0 　

请给出完整SQL语句！！！！！！

[vision2000]

SELECT table.a,count(table.b),count(table.c) FROM table GROUP BY table.a HAING table.c is not null

[wenchanyee]

select table1.a,table1.b,table2.c from
(selec a ,count(b) from table group by a ) as table1
(selec a, count(c) from table group by a where not c is null) as table2
where table1.a = table2.a

[wenchanyee]

SELECT table.a,count(table.b),count(table.c) FROM table GROUP BY table.a HAING table.c is not null

的结果是
001 2 2
002 2 2
003 0 0

[wenchanyee]

SELECT a,count(b),count(c) FROM tata GROUP BY a

正确 是这个
刚试了。。。。
郁闷

[ctihy_yy]

select a,count(b) as c1,count(c) as c2
from table
where c =''

[ctihy_yy]

不好意思，写错了
select a,count(b) as c1,count(c) as c2
from table
where c <>''

[flyfishcn]

wenchanyee(叶文强) ：

select table1.a,table1.b,table2.c from
(selec a ,count(b) from table group by a ) as table1
(selec a, count(c) from table group by a where not c is null) as table2
where table1.a = table2.a

结果为：
　　　001 2 2
002 3 2

003就没有了。。。

[zzlazio]

SELECT a,count(b),count(c) FROM table GROUP BY a
HAING c is not null

[flyfishcn]

zzlazio(sritsb)：
SELECT a,count(b),count(c) FROM table GROUP BY a
HAING c is not null

服务器: 消息 8121，级别 16，状态 1，行 11
列 'table.c' 在 HAVING 子句中无效，因为该列既不包含在聚合函数中，也不包含在 GROUP BY 子句中。

[fly_cat_]

select a.hdpc,a.zcs,count(b.hdbz) as zcyhds from
(select zchdpc as hdpc,count(zcbh) as zcs from zchdjd group by zchdpc) a
left join zchdjd b
on b.zchdpc =a.hdpc and b.hdbz <> '' group by a.hdpc,a.zcs

[flyfishcn]

只有fly_cat_(1) 方法管用！！

[matrix1996]

Select aaa.a,Count(aaa.b),Sum(aaa.c)
From (Select a,b,Case When c is null then 0 else 1 end From Table) aaa
group by aaa.a

[matrix1996]

Select aaa.a,Count(aaa.b),Sum(aaa.c)
From (Select a,b,Case When c is null then 0 else 1 end c From Table) aaa
Group by aaa.a

[cnzw002]

菜人年年有，今年特别多
怎么那么多和我一样的

[flyfishcn]

matrix1996(铁血)
的方法不错，挺简洁！！！