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