Snippet Name: Kill Dupes- "Shoot On Sight" Description: Absolutely, positively removes duplicate records from a given table. Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 03rd, 2009
Description: Absolutely, positively removes duplicate records from a given table.
DELETE FROM my_table WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM my_table GROUP BY delete_col_name);