oracle优化文章

http://caihorse.iteye.com/blog/538432

?

删除重复记录的SQL

SELECT * FROM aaa E WHERE E.ROWID > (SELECT MIN(X.ROWID) FROM aaa X WHERE X.AA = E.AA);

?

DELETE FROM aaa E WHERE E.ROWID > (SELECT MIN(X.ROWID) FROM aaa X WHERE X.AA = E.AA);