SQL Server: Select Distinct on one column with multiple columns returned

Try this by same logic. As i have created Temporary test query.

It may help you.

-- @Temp Your table name

DECLARE @Temp AS TABLE(
		Id Integer
		,Name VARCHAR(10)
)

INSERT INTO @Temp
SELECT 1 , 'a' 
UNION  
SELECT 2 , 'a' 
UNION
SELECT 3 , 'b' 
UNION
SELECT 4 , 'b'


SELECT DISTINCT  (SELECT Top 1 Id FROm @Temp t WHERE t.Name = t1.Name) Id
	             ,Name
FROM @Temp t1