Try this
CREATE TABLE #TempTable
(Id INT, [Name] VARCHAR(50))
INSERT INTO #TempTable
SELECT 1, 'A' UNION
SELECT 2, 'A' UNION
SELECT 3, 'A' UNION
SELECT 4, 'B' UNION
SELECT 5, 'B' UNION
SELECT 6, 'B' UNION
SELECT 7, 'C' UNION
SELECT 8, 'C' UNION
SELECT 9, 'C'
SELECT MIN(Id) AS Id, [Name] FROM #TempTable
GROUP BY [Name]
DROP TABLE #TempTable