how can i run this query in code igniter

how can i run this query in code igniter - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: how can i run this query in code igniter (/showthread.php?tid=61150)

how can i run this query in code igniter - El Forum - 10-02-2014

[eluser]rajneeshgobin[/eluser]
how can i write this kind of query in code igniter

basically it tells me which rows of my table has duplicates based on the selected parameters in this case role id and perm id

select roleID, permID, count(*) as NumDuplicates
from `role_perms`
group by roleID, permID
having NumDuplicates > 1

how can i run this query in code igniter - El Forum - 10-02-2014

[eluser]CroNiX[/eluser]

Code:
$this->db

  ->select('roleID, permID')

  ->select('count(*) as NumDuplicates', FALSE)

  ->group_by(array('roleID', 'permID'))

  ->having('NumDuplicates > 1')

  ->get('role_perms')

  ->result();

Code:
//Produces

SELECT roleID, permID, count(*) as NumDuplicates

FROM (role_perms)

GROUP BY roleID, permID

HAVING NumDuplicates > 1

Haven't tried it as I don't have your tables, but probably something like that