ORACLE 删除重复数据

TABLE_NAME->使用时替换为本地表名；

COLUMN_NAME1等->使用时替换为相应字段。

示例：

DELETE TABLE_NAME
 WHERE (COLUMN_NAME1, COLUMN_NAME2, COLUMN_NAME3) IN
       (SELECT COLUMN_NAME1, COLUMN_NAME2, COLUMN_NAME3
          FROM TABLE_NAME
         GROUP BY COLUMN_NAME1, COLUMN_NAME2, COLUMN_NAME3
        HAVING COUNT(*) > 1)
   AND ROWID NOT IN (SELECT MIN(ROWID)
                       FROM TABLE_NAME
                      GROUP BY COLUMN_NAME1, COLUMN_NAME2, COLUMN_NAME3
                     HAVING COUNT(*) > 1);