Delete Duplicate Rows From Table In Sql Server

Delete Duplicate Rows From Table In Sql Server with No Identity Column in table
 
 If you want to delete Duplicate rows from sql server table with no identity column here is the trick
 
 Consider table given below say sampletable
 
 id data
 1 A
 2 B
 1 A
 3 C
 1 A
 2 B
 1 A
 
 If you want to delete duplicate rows in sql server
 here is the trick with common table expression as given
 
 WITH CTE AS
 (
 SELECT *,RN=ROW_NUMBER() OVER (PARTITION BY id ORDER BY id DESC) FROM sampletable
 )
 DELETE FROM CTE WHERE RN > 1
  
Ebook Download
View all
SQL Jobs
Read by 0 people
Download Now!
Learn
View all