Outside the Cube (7611)
Web publishing (65)
New related comments
Number of comments in the last 48 hours
Compare MS-SQL (2000, 7.0 and 6.5) with Oracle
Remove duplicate rows from a table - independent from indexes
11 comments. Current rating: (6 votes). Leave comments and/ or rate it.
Question:I need to remove duplicate rows from my table. It has an autoincrement integer as primary key and a few other attributes (PROD_ID, RESOURCE_ID, DATE_ADDED). What's the easiest way to do that?
Answer:Follow these steps: