Last answered:

16 Jun 2020

Posted on:

21 May 2020

0

How to Delete Duplicate record under SQL

How can i delete duplicate records from a table under SQL 
1 answers ( 0 marked as helpful)
Instructor
Posted on:

16 Jun 2020

0
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

Submit an answer