怎么统计这些数据中0与1个数

select

DIAOCJG1, DIAOCJG2, DIAOCJG3, DIAOCJG4, DIAOCJG5, DIAOCJG6, DIAOCJG7, DIAOCJG8, DIAOCJG9, DIAOCJG10, DIAOCJG11, DIAOCJG12, DIAOCJG13, DIAOCJG14, DIAOCJG15, DIAOCJG16, DIAOCJG17, DIAOCJG18, DIAOCJG19, DIAOCJG20
from table1

select count(*), diaocjg1 from 表名 group by diaocjg1

SELECT diaocjg1, COUNT(diaocjg1) as counter
FROM table1
WHERE diaocjg1='1' OR diaocjg1='0'
GROUP BY diaocjg1;