联合查询总数怎样使查询结果为一条数据

[pjw001]

如我要查询
select count(*) as aa from 表A where A=1 and B=100 查询A=1 和B=100共有多少条数据
select count(*) as bb from 表A where A=1 and B=100 and C<>'' 查询A=1 和B=100 and c<>'' 共有多少条数据
如果aa有30条bb有10条怎样使查询结果为
aa bb
30 10

而不是二条数据
30
10

[feixianxxx]

select aa=(select count(*)from 表A where A=1 and B=100 ),
bb=(select count(*) as bb from 表A where A=1 and B=100 and C <>'')

[sql_db]

select count(*) as aa,sum(case when C <>' then 1 else 0 end) as bb from 表A where A=1 and B=100 

[sql_db]

select count(*) as aa,sum(case when C <>'' then 1 else 0 end) as bb from 表A where A=1 and B=100

[东那个升]

select sum(case when A=1 and B=100 then 1 else 0 end ) as aa
,sum(case A=1 and B=100 and C <>'' then 1 else 0 end ) as bb 
from 表A

[东那个升]

,sum(case when A=1 and B=100 and C <>'' then 1 else 0 end ) as bb

丢了when

[xiaoliaoyun]

SELECT A.aa,B.bb FROM 
(select count(*) as aa from 表A where A=1 and B=100)A
,(select count(*) as bb from 表A where A=1 and B=100 and C <>'')B

[pjw001]

不好意思先给的先得分呵呵。分不高谢谢各位了