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);