- How can I count the answers that have the same values?
- --Table Answer--
- Id Question_id Attendee_id Answer
- 100 qst1 001 Name1
- 101 qst2 001 Name1
- 102 qst3 002 Name2
- SELECT Answer, COUNT(*) FROM MyTable GROUP BY Answer
- Select Answer, Count(*) FROM answer GROUP BY Answer
- SELECT answer,COUNT(*) FROM table
- GROUP BY answer
- SELECT
- Question_id,
- Answer,
- COUNT(1) qty
- GROUP BY
- Question_id, Answer