ORACLE删除重复记录

删除重复记录：

表：S_TEST  字段：COLUM1、COLUM2、COLUM3

(单个字段重复)

DELETE FROM S_TEST

 WHERE COLUM1 IN

       (SELECT COLUM1 FROM S_TEST  GROUP BY COLUM1 HAVING COUNT(1) > 1)

   AND ROWID NOT IN

       (SELECT MIN(ROWID) FROM S_TEST  GROUP BY COLUM1 HAVING COUNT(1) > 1);

（多个字段重复）

DELETE FROM S_TEST

 WHERE (COLUM1, COLUM2) IN (SELECT COLUM1, COLUM2

                               FROM S_TEST

                              GROUP BY COLUM1, COLUM2

                             HAVING COUNT(1) > 1)

 AND ROWID NOT IN (SELECT MIN(ROWID)

                               FROM S_TEST

                              GROUP BY COLUM1, COLUM2

                             HAVING COUNT(1) > 1)