Find and remove duplicates

 

How to find and remove duplicates.

Find and remove duplicates.

 

Select duplicates:

 

Remove duplicates with a DELETE statement:

Remove duplicates with a new unique key:

 

This ALTER TABLE with IGNORE keyword will create new unique key and remove all duplicates from the table in a one step.

Leave a Reply

Your email address will not be published. Required fields are marked *