现有表TBA如下，ZA只能输1或不输，ZB只能输2或不输.........ZE只能输5或不输
id ZA ZB ZC ZD ZE
1 1 2 5
2 2 4 5
3 1 3 4
4 2 3 3
5 2 4 5
要统计各个数字出现的次数
select count(za),count(zb),count(zc),count(zd),count(ze) from TBA group by za,zb,zc,zd,ze
以上写法怎么不正确？
SQL code:
select sum(case when za=1 then 1 else 0 end)za次數,
sum(case when zb=2 then 1 else 0 end)zb次數,
sum(case when zc=3 then 1 else 0 end)zc次數,
sum(case when zd=4 then 1 else 0 end)zd次數,
sum(case when za=5 then 1 else 0 end)ze次數
from tba
create table tb (a int,b int,c int,d int,e int)
insert into tb values (1,2,3,4,5)
insert into tb values (null,null,null,null,null)
insert into tb values (null,2,null,4,5)
insert into tb values (1,null,3,4,null)
insert into tb values (null,2,3,null,5)
insert into tb values (1,2,null,null,5)
select count(a),count(b),count(c),count(d),count(e) from TB
如果你说的不输是"NULL" 那就这样即可
高手 能否用count group by实现？
{{----
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
上面一个简单的SQL,执行时间2.6� ......
