srboisvert srboisvert - 3 months ago 6
Ruby Question

How to find records that have duplicate data using Active Record

What is the best way to find records with duplicate values in a column using ruby and the new Activerecord?

Answer

Translating @TuteC into ActiveRecord:

sql = 'SELECT id, COUNT(id) as quantity FROM types GROUP BY name HAVING quantity > 1'
#=>
Type.select("id, count(id) as quantity").group(:name).having("quantity > 1")
Comments