Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links

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 

By      06-Dec-2023    2

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

Your Answer

10040
Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links