Removing _duplicates_from_Rails_postgres_database.rb

def self.remove_dup
  #SubWorking.select(:sub_working_title).group(:sub_working_title).having("count(*) > 1")
  value = nil
  SubWorking.order("sub_working_title ASC").each do |record|
    if record.sub_working_title == value
      # duplicate
      record.destroy
    else
      # first entry
      value = record.sub_working_title
    end
  end
end

def self.remove_dup
  value = nil
  Specialist.order("name ASC").each do |record|
    if record.name == value
      # duplicate
      record.destroy
    else
      # first entry
      value = record.name
    end
  end
end