SELECT * FROM
ROW_NUMBER() OVER (PARTITION BY LastName, FirstName ORDER BY Lastname,FirstName) AS RN
)s WHERE RN=1;The key thing to notice is the partition clause shown in red. It will give you one row per unique combination of whatever you put in there. The order by clause is something that I put in because I don't know any better. If you order them by City, for example, you will get the row with the first city.