How can i delete duplicate records from a table under SQL

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

Follow this topic

Oshin Olamilekan

Last answered:

16 Jun 2020

Posted on:

21 May 2020

How to Delete Duplicate record under SQL

1 answers ( 0 marked as helpful)

Martin Ganchev

Instructor

Posted on:

16 Jun 2020

How to Delete Duplicate record under SQL

Submit an answer