Kill Dupes- “Shoot On Sight”

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);

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.