How to delete Duplicates Row in Table
Aslamualaekum Every One
I have a Employee table There is many duplicate rows i want to delete duplicate Please Help
Solutions
Rizwan Saqib
WITH CTE AS(
SELECT Column1,Column2,
Rnumber = ROW_NUMBER()OVER(PARTITION BY Column1 ORDER BY Column1)
FROM TableName
)
DELETE FROM CTE WHERE RNumber > 1