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