Skip to content

Instantly share code, notes, and snippets.

@jeanfbrito

jeanfbrito/find_dups.rb

Forked from rob-murray/find_dups.rb
Created September 29, 2021 00:20
Show Gist options
  • Save jeanfbrito/53746a2d6a6a6ccc8ebfbb0bcc4751f3 to your computer and use it in GitHub Desktop.
Save jeanfbrito/53746a2d6a6a6ccc8ebfbb0bcc4751f3 to your computer and use it in GitHub Desktop.
Download ZIP
Rails find duplicate records
Raw
find_dups.rb
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment