#title Find duplicates in a table
#author Stefan Hornburg (Racke)
#topics blog; MySQL
#date 2012-10-16
#pubdate 2012-10-16T08:53:44+02:00
#lang en



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

<example>

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

</example>