oracle优化文章http://caihorse.iteye.com/blog/538432?删除重复记录的SQLSELECT * FROM aaa E WHERE E.RO
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);