Syed DBA
Saturday, April 28, 2012
Delete duplicate rows
DELETE FROM <table> A WHERE ROWID > (
SELECT min(rowid) FROM <table> B
WHERE A.key_column = B.key_column);
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment