SELECT [Count], MAX(Name)

FROM tbl

GROUP BY  [Count]

Or, if you want more data on the same row:

; WITH CTE AS (

SELECT *, rowno = row_number() OVER(PARTITON BY [Count] ORDER BY Name DESC)

FROM tbl

)

SELECT *

FROM CTE

WHERE rowno = 1

Note that this forum is for security-related questions, for which your post does not seem to qualify.