Delete Duplicate Records From A Table In SQL Server

In this blog, I would like to share a simple way to delete the duplicate record from a table, using ROW_NUMBER ()

Step 1

Table structure

Step 2

Query for inserting record into an Employee table

Step 3

#Employee table contains duplicated records given below.

SELECT * FROM #Employee

Step 4

Delete the duplicate record, using ROW_NUMBER ()

SELECT EmpID, EmpName, EmpSalary, ROW_NUMBER() OVER(PARTITION BY EmpName, EmpSalary ORDER BY EmpID) AS RowNumber INTO# EmployeeFinal
FROM# Employee
DELETE
FROM# Employee
WHERE EmpID IN(SELECT EmpID FROM# EmployeeFinal WHERE RowNumber > 1)

Step 5

After the deletion of the duplicate rows from the #Employee table, it displays, as shown below.