How to find the duplicate values in MySQL

In this post we are discussing about how to find the duplicate values in MySQL. There are a lot of scenarios in which we found this post helpfull.We can find the duplicate values in in MySQL table using the SELECT Query

SELECT column_name, COUNT(*) c FROM table GROUP BY coloumn_name HAVING c > 1;

This will return a result with the column_name value in the first column, and a count of how many times that value appears in the second.

That’s it and hope this post help you to know how to find the duplicate values in MySQL

Leave a Reply

Your email address will not be published.