Here is example of how to delete duplicate rows with duplicate FirstName,LastName columns from Customers
Using Common Table Expression (CTE) in SQL...
-- ONLY in SQL 2005 - USING CTE and ROW_NUMBER()
WITH DUPLICATE(ID, RowNumber)
,ROW_NUMBER() OVER (PARTITION BY ID order by ID) AS...
Separate names with a comma.