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) AS ( SELECT ID ,ROW_NUMBER() OVER (PARTITION BY ID order by ID) AS...
Separate names with a comma.
