CodeIgniter Forums
How Can I Get a Count Of Grouped Records? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: How Can I Get a Count Of Grouped Records? (/showthread.php?tid=56426)



How Can I Get a Count Of Grouped Records? - El Forum - 12-18-2012

[eluser]Unknown[/eluser]
First, thanks for Gas ORM. It's awesome.

I am trying to count grouped values as in the query:

Code:
SELECT question_id, answer_value, count( id ) AS count_answer
FROM response
GROUP BY question_id, answer_value

Any help would be greatly appreciated.

Thanks, again.