Oracle PL/SQL: Kill Dupes- "Shoot On Sight" - Absolutely, positively removes duplicate records from a given table.

Quick Search:

Oracle PL/SQL: Kill Dupes- "Shoot On Sight"

Jump to:

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

DELETE FROM my_table 
 WHERE ROWID NOT IN (SELECT MIN(ROWID) 
             FROM my_table 
             GROUP BY delete_col_name);