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;