在同一领域

Question

MYSQL SELECT 2个计数想象一下这样的数据库结构：

`id` int(11) unsigned NOT NULL AUTO_INCREMENT, 
`correct` tinyint(1) NOT NULL DEFAULT '0' 

我想所有条目的数量与correct = 1，和与correct = 0所有条目的数量，在一个查询。

我该怎么做？

Answer 1

使用GROUP BY应该解决的问题：如果你想在一排的计数

SELECT correct, COUNT(*) FROM table GROUP BY correct; 

Answer 2

select count(case when correct = 0 then 1 end) as ZeroCount, 
    count(case when correct = 1 then 1 end) as OneCount 
from MyTable 

Answer 3

：

SELECT SUM(correct=0) as number_of_zeros,SUM(correct=1) as number_of_ones 
FROM table; 

如果你希望他们在多行：

SELECT correct,COUNT(*) 
FROM table 
GROUP BY correct;