Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Delete Duplicate Rows From Table In Sql Server with No Identity Column in table
Amol
Jul 29 2012 4:42 AM
1.5k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
SQL Profiler in SQL Server
SQL Distinct