Oracle删除重复数据

创建表用于测试：

删除表中的重复的数据，保存rowid最小的一个数据：

DELETE FROM tbl_a a
WHERE 
       a.a_name IN (SELECT b.a_name FROM tbl_a b GROUP BY b.a_name HAVING COUNT(b.a_name)>1)
AND 
       ROWID NOT IN (SELECT MIN(ROWID) FROM tbl_a c GROUP BY c.a_name HAVING COUNT(*)>1);

输出后的表：

最近查到一篇文章有其他的方法，待校验
http://www.jb51.net/article/84937.htm