In SQL, how do I delete a duplicate record from a table?

Forums SQLIn SQL, how do I delete a duplicate record from a table?
Staff asked 2 years ago

Answers (1)

Add Answer
Staff answered 2 years ago

To 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;

 

Subscribe

Select Categories