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

Back to all questions

How to Delete Duplicate record under SQL

6 months ago
Vote Up Vote Down
0
Votes
1
Answer

How can i delete duplicate records from a table under SQL 

#, #
1 Answer

365 Team 5 months ago
Vote Up Vote Down
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

You must to answer this question.

Not the answer you are looking for? Browse other questions tagged #, #.

×
Complete Data Science Training
Save 60%