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;