In this post, I am sharing a demonstration on how to remove all rows except for one in MySQL. Before a few days ago, I was working in one of our production reports and found that there are a lot of duplicate records. This table has more than 2,00,00,000 records and I removed duplicate based … Continue reading Delete all duplicate rows in MySQL