SELECT barcode, 
 COUNT(barcode) AS NumOccurrences
FROM [ITN_SOFT].[dbo].[products]
GROUP BY barcode
HAVING ( COUNT(barcode) > 1 )