Select ItemID,Count(ItemID) FROM TableA group by ItemID Having Count(ItemID)>1
SELECT TableA_1.ItemId FROM dbo.TableA TableA_1 INNER JOIN dbo.TableA TableA_2 ON TableA_1.ItemId = TableA_2.ItemId AND TableA_1.SupplierId <> TableA_2.SupplierID --This should only give you the duplicated ItemId with different SupplierId, if you only want the duplicated ItemId, remove the last condition.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)