Delete duplicate records from Table using SQL

DeuplicateTable

Thank you for reading this post, don't forget to subscribe!

1     ABC   10

1     ABC   10

1     ABC   10

1     ABC   10

1     ABC   10

2     XYZ   12

2     XYZ   12

2     XYZ   12

2     XYZ   12

2     XYZ   12

 

;WITH OrderedResults AS

(

SELECT ROW_NUMBER() OVER(PARTITION BY SRNO,NAME,CLASS ORDER BY SRNO) AS ROWNUMBER, * FROM #TEMP_TABLE2

)

DELETE OrderedResults WHERE ROWNUMBER<>1

 

 

OUT PUT:-

1     ABC   10

2     XYZ   12