Sqlite - SELECT COUNT (* how many times the value is stored *)

Question

I have a database of questions and answers. In the answers a specific question will save a yes / no entry to the database.

So, my table has an answer column that will have a yes or no value.

I want to be able to count how many times yes is stored and how many times no is stored.

Therefore, I could do this using two queries, for example:

SELECT COUNT(*) WHERE answer="yes";
SELECT COUNT(*) WHERE answer="no";

Is there a way to do this in a single request?

thank

+3

Thomas clayson Jun 17 '11 at 11:33

3 answers

Try this one

SELECT
sum(CASE WHEN answer="yes" THEN 1 ELSE 0 END) countyes,
sum(CASE WHEN WHERE answer="no" THEN 1 ELSE 0 END) countNO
FROM table

+1

Syeda Jun 17 '11 at 11:46

SELECT "yes answers", COUNT(*) WHERE answer="yes"
UNION 
SELECT "no answers", COUNT(*) WHERE answer="no";

0

Maksee Jun 17 '11 at 11:41

Denis de bernardy · Accepted Answer · 2011-06-17T11:36:13+0000

group it:

select answer, count(*) from yourtable group by answer;