How can I count the answers that have the same values?

Question

I have a table like this:

--Table Answer--
Id     Question_id  Attendee_id  Answer
100    qst1          001         Name1
101    qst2          001         Name1
102    qst3          002         Name2

I would like to know how I can count the answers that have the same values?

score 2 · Answer 1 · answered Dec 13 '11 at 14:42

2

A standard SQL aggregate

SELECT Answer, COUNT(*) FROM MyTable GROUP BY Answer

answered Dec 13 '11 at 14:42

gbn

408,740
77
567
659

score 2 · Answer 2 · answered Dec 13 '11 at 14:42

2

Select Answer, Count(*) FROM answer GROUP BY Answer

answered Dec 13 '11 at 14:42

Flo

1,640
4
21
34

score 2 · Answer 3 · answered Dec 13 '11 at 14:44

2

SELECT answer,COUNT(*) FROM table
GROUP BY answer

answered Dec 13 '11 at 14:44

Tim Sparg

3,254
2
26
39

score 1 · Answer 4 · answered Dec 13 '11 at 14:42

1

For every question?

SELECT
    Question_id,
    Answer,
    COUNT(1) qty
GROUP BY
    Question_id, Answer

Exclude Question_id from SELECT and GROUP BY if you want the total counts, not partitioned by question, although I assume that figure would be less useful.

answered Dec 13 '11 at 14:42

David Hedlund

125,403
30
199
217

Note that COUNT(1) being "better" is a myth: http://stackoverflow.com/a/1221649/27535. And wrong syntax too... – gbn Dec 13 '11 at 14:44
@gbn: sure, it's just an old habit. it's not worse either, for the very same reasons :) – David Hedlund Dec 13 '11 at 14:46

How can I count the answers that have the same values?

4 Answers4