Outside the Cube (8485)
Web publishing (65)
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: