Monday, June 13, 2011

Remove duplicates rows from a table?

SQL> DELETE FROM table_name A WHERE ROWID > (
2 SELECT min(rowid) FROM table_name B
3 WHERE A.key_values = B.key_values);

No comments: