SELECT P.Id, P.Name, P.Amount FROM person P INNER JOIN ( SELECT Min(Id) AS Id, Name FROM person GROUP BY Name ) T ON P.Id = T.Id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)