sql数据个数统计

Question

sql表1中有两列数据：
1列 2列
5 6
7 8
6 5
6 7
7 5
如果，我想要统计这两列数据数据中5的个数，怎么写语言啊~

Answer 1

SELECT (SELECT COUNT(*) FROM [表1] WHERE [1列] = 5) + (SELECT COUNT(*) FROM [表1] WHERE [2列] = 5)追问

Count后面那个括号里面是什么啊~我还想把总数存在表2里面~一句话完成能吗

追答

括号里面就是星号
插入表2
INSERT INTO [表2]

SELECT (SELECT COUNT(*) FROM [表1] WHERE [1列] = 5) + (SELECT COUNT(*) FROM [表1] WHERE [2列] = 5)

本回答被提问者采纳

Answer 2

SELECT
SUM(CASE WHEN [1列]=5 THEN 1 ELSE 0 END) [1列],
SUM(CASE WHEN [2列]=5 THEN 1 ELSE 0 END) [2列]
FROM [表]

Answer 3

--(ORACLE)
select sum(case when a1=5 and a2=5 then 2
when (a1=5 and a2<>5) or (a2=5 and a1<>5) then 1
else 0
end)
from table_name;

Answer 4

如果是2列总的5的个数的话可以把2列的数据合并成1列在进行group by追问

能用一句话写出来吗~我还要保存在表2中~用于labview编程

Answer 5

是 总共5的个数，还是每列分开统计追问

总共的个数，而且要储存在表2中~

追答

insert #a select 5 , 6
insert #a select 7 , 8
insert #a select 6 , 5
insert #a select 6 , 7
insert #a select 7 , 5
create table #a (a int,b int)

分开统计两列 ：select (select count(*) as a from #a where a=5) as a ,(select count(*) as b from #a where b=5) as b

两列统计到一起：
select count(*) as a from
(select a from #a where a=5
union all

select b from #a where b=5) t