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

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


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