Deleting old repeated records
I would like to merge data at a central level from different clinics' databases that are using the same patient database. (I am using importing from file). The imported records may have an older clone of them in the host databse. I wonder how can I delete those old repeated records and keep only the updated ones during importing or by using a special script to delete them.