S
sb8s
Guest
I have a database with about 10,000 records, 600 or so of which are duplicates. I want to delete not only the duplicate for each, but also the original. In other words, if John Smith appears twice in the database, I want to delete him from the database entirely. Is there any way to do this without identifying the duplicates and deleting both instances manually?
I know how to append only unique records to a new table, but that only gets rid of the duplicates (second, third, fourth instances, etc.) for each record.
Thanks in advance.
I know how to append only unique records to a new table, but that only gets rid of the duplicates (second, third, fourth instances, etc.) for each record.
Thanks in advance.