How delete Duplicate Rows in Table
- MS Sql Server
- 685
- March-26-2018
- by Rizwan Saqib
WITH DeleteDuplicate_Rows
AS (
SELECT
E.Name
,Row_Number()Over(Partition By E.name Order by Name )AS DuplicateRows
FROM Employee E)
Delete from DeleteDuplicate_Rows
Where DuplicateRows > 1
