In SQL, how do I delete a duplicate record from a table?
Answers (1)
Add AnswerTo eliminate duplicate entries in SQL Server, we may use Common Table Expressions (CTE).
WITH CTE([FirstName], [LastName], [Country], DuplicateCount) AS (SELECT [FirstName], [LastName], [Country], ROW_NUMBER() OVER(PARTITION BY [FirstName], [LastName], [Country] ORDER BY ID) AS DuplicateCount FROM [SampleDB].[dbo].[Employee]) DELETE FROM CTE WHERE DuplicateCount > 1;