how to find duplicate records in mysql

There are many a occasions when you need to find duplicate values available in a column of a MySql table. Often, you may want to count the number of duplicate values in a MySQL table.

SELECT * FROM `amazon_cat_reqs` group by prod_id having count(*) >= 2

Was this article helpful?

Related Articles