The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

How to Delete Duplicate record under SQL

How to Delete Duplicate record under SQL

0
Votes
1
Answer

How can i delete duplicate records from a table under SQL 

1 Answer

365 Team
0
Votes

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

×
Ready to Learn
Data Science?
50% OFF