Select A.ID, A.Name, A.score
From Temp A, (Select Name, Max (Score) AS Max_score from Temp Group By Name B
Where a.name = B.NAME
And a.score = b.max_score
