1
Reply

Remove duplicate record from a table

Anjali Khan

Anjali Khan

Sep 29 2017 11:42 AM
162
Hi frnds How to remove duplicate records from a table? I know from the below query but my table name is employee so y we used tempemp . Remove Duplicate Records by using ROW_NUMBER() WITH TempEmp (Name,duplicateRecCount) AS. ( SELECT Name,ROW_NUMBER() OVER(PARTITION by Name, Salary ORDER BY Name) AS duplicateRecCount. FROM dbo. Employee. ) --Now Delete Duplicate Records

Answers (1)