Code. Collaborate. Organize.
No Limits. Try it Today.
SELECT P.Id, P.Name, P.Amount FROM person P
SELECT Min(Id) AS Id, Name FROM person
GROUP BY Name
) T ON P.Id = T.Id
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)