How to delete Duplicates Row in Table Ask Question
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
