--finding EAN duplicates in Products

select top (10) Products_ProductDetails_UnitEAN, count(Products_ProductDetails_UnitEAN) as NumOccurences
FROM [Framework_REAP-1].[dbo].[publ_Products]
where isActive = 1
group by Products_ProductDetails_UnitEAN
having ( count(Products_ProductDetails_UnitEAN) > 1 );