Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 15th, 2012  |  syntax: None  |  size: 0.48 KB  |  hits: 16  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How can I count the answers that have the same values?
  2. --Table Answer--
  3. Id     Question_id  Attendee_id  Answer
  4. 100    qst1          001         Name1
  5. 101    qst2          001         Name1
  6. 102    qst3          002         Name2
  7.        
  8. SELECT Answer, COUNT(*) FROM MyTable GROUP BY Answer
  9.        
  10. Select Answer, Count(*) FROM answer GROUP BY Answer
  11.        
  12. SELECT answer,COUNT(*) FROM table
  13. GROUP BY answer
  14.        
  15. SELECT
  16.     Question_id,
  17.     Answer,
  18.     COUNT(1) qty
  19. GROUP BY
  20.     Question_id, Answer