求SQL语句：马上结帐
表 : table
字段：a,b,c
我想查询
a 字段里面有多少个等于1的
b 字段里面有多少个等于1的
c 字段里面有多少个等于1的
[解决办法]
什么叫多少个等于1的?
是a字段里包含多少个1?还是?
[解决办法]
select (select count(*) from table where a=1),(select count(*) from table where b=1),(select count(*) from table where c=1)
[解决办法]
有多少个a字段等于1的》？
[解决办法]
select * from (select count(*) aCount from table where a=1) a,(select count(*) bCount from table where b=1)b ,(select count(*) cCount from table where c=1) c
[解决办法]
select top 1 (select count(a) from table where a = 1)aCount,(select count(b) from table where b = 1)bCount,(select count(c) from table where c = 1)cCount from table
[解决办法]
是表table
列a,b,c吧?
[解决办法]
select count(*) from table where a =1
select count(*) from table where b =1
select count(*) from table where c =1
[解决办法]
LZ表达不清楚
[解决办法]
select count(*) as [A列1的个数] from table where a =1
union all select count(*)[B列1的个数] from table where b =1
union all select count(*)[C列1的个数] from table where c =1
[解决办法]
--准备数据
declare @table table(
a int,
b int,
c int
)
insert into @table values(1,1,1)
insert into @table values(1,0,1)
insert into @table values(1,1,0)
insert into @table values(0,1,1)
insert into @table values(1,0,0)
insert into @table values(0,1,0)
insert into @table values(0,0,1)
select * from @table
--方法1,个人比较喜欢这个
declare @counta int
declare @countb int
declare @countc int
set @counta=0
set @countb=0
set @countc=0
select @counta=@counta+(case a when 1 then 1 else 0 end)
,@countb=@countb+(case b when 1 then 1 else 0 end)
,@countc=@countc+(case c when 1 then 1 else 0 end)
from @table
select @counta,@countb,@countc
--方法2
select (select count(a) from @table where a=1),(select count(b) from @table where b=1),(select count(c) from @table where c=1)
--方法3
select ta.a,tb.b ,tc.c
from (
select 1 as k, count(a) as a from @table where a=1 ) ta
inner join (select 1 as k, count(b) as b from @table where b=1) tb on ta.k=tb.k
inner join (select 1 as k, count(c) as c from @table where c=1) tc on ta.k=tc.k
[解决办法]
SQL> select * from test1;
A B C
---------- ---------- ----------
1 1 1
1 2 3
3 1 1
SQL> select count(*) from test1 where A=1
2 union all
3 select count(*) from test1 where B=1
4 union all
5 select count(*) from test1 where C=1;
COUNT(*)
----------
2
2
2
