Title: Find duplicates in a table
Topics: blog, MySQL
Date: 2012-10-16

Stefan Hornburg (Racke)

Find duplicates in a table

Sometimes you want to find "duplicates" in a database table: 


select sku, count(sku) from media_products group by sku having count(sku) > 1;