jeanfbrito/find_dups.rb

Forked from rob-murray/find_dups.rb

Created September 29, 2021 00:20

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jeanfbrito/53746a2d6a6a6ccc8ebfbb0bcc4751f3.js"></script>
Save jeanfbrito/53746a2d6a6a6ccc8ebfbb0bcc4751f3 to your computer and use it in GitHub Desktop.

Download ZIP

Revisions

Robert Murray created this gist Oct 27, 2015.

find_dups.rb

-Original file line number
+Diff line change
@@ -0,0 +1,4 @@
+    columns_that_make_record_distinct = [:some_id, :another_name]
+    distinct_ids = Model.select("MIN(id) as id").group(columns_that_make_record_distinct).map(&:id)
+    duplicate_records = Model.where.not(id: distinct_ids)