The Chronicles of Xaiver
The scribe of Xaiver's life.
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment