oracle删除表中重复数据

使用rowid：

DELETE from fb_b_info

 WHERE div_code IN (SELECT div_code FROM fb_b_info GROUP BY div_code HAVING COUNT(div_code) > 1) --查询重复列
   AND ROWID NOT IN

       (SELECT MIN(ROWID) FROM fb_b_info GROUP BY div_code HAVING COUNT(*) > 1); --保留rowin最小的那一行数据

这是删除重复列的一种方法，其它方法以后补充。

祝：工作顺利！