SQL - Counting a column twice

Question

I have a table that has a column called 'status'. This can be set to 0 or 1

Is it possible for me to count both the 0's and 1's in a single query?

Thanks in advance

James

Both current answers are good - Yuck's if you need pure counts, ean5533's if you need to add further columns/more grouping — Damien_The_Unbeliever, Feb 16 '12 at 18:22

score 9 · Accepted Answer · answered Feb 16 '12 at 18:19

Yes, just group on the value of status:

SELECT status, COUNT(*)
FROM yourtable
GROUP BY status

That will give you exactly two rows since the value can only be 0 or 1, and the COUNT(*) column will be the number of times each status value appears in the table.

score 9 · Answer 2 · answered Feb 16 '12 at 18:20

9

SELECT SUM(CASE WHEN status = 0 THEN 1 ELSE 0 END) AS 'number of zeroes',
       SUM(CASE WHEN status = 1 THEN 1 ELSE 0 END) AS 'number of ones'
FROM yourtable;

answered Feb 16 '12 at 18:20

ean5533

8,884
3
40
64

SQL - Counting a column twice

2 Answers2

Linked