Jan 26, 2018 02:07 PM|PatriceSc|LINK
Try SELECT MAX(Id),FirstName,LastName FROM YourTable GROUP BY FirstName,LastName. See
https://docs.microsoft.com/en-us/sql/t-sql/queries/select-group-by-transact-sql for details.
Note though that strictly speaking it is not impossible to have two distinct persons with the same FirstName, LastName (ie if you try to clean up an existing database you could have this issue).