How to Delete Duplicate record under SQL
How can i delete duplicate records from a table under SQL
1 answers ( 0 marked as helpful)
Hi Oshin!
Thanks for reaching out.
Please accept my apologies for the delayed response.
There are several ways to remove duplicate rows in MySQL. Which one to choose will depend on your settings and database.
Adding a UNIQUE index on the columns of a table is one way, by using a DELETE statement with a WHERE condition is the other. Perhaps these are the two most frequently encountered solutions. Hope this helps.
Best,
Martin
Adding a UNIQUE index on the columns of a table is one way, by using a DELETE statement with a WHERE condition is the other. Perhaps these are the two most frequently encountered solutions. Hope this helps.
Best,
Martin