ORACLE删除重复记录

删除重复记录：

表：S_TEST  字段：COLUM1、COLUM2、COLUM3

(单个字段重复)

DELETE FROM S_TEST

 WHERE COLUM1IN

       (SELECT COLUM1FROM S_TEST GROUP BY COLUM1HAVING COUNT(1) > 1)

   AND ROWID NOT IN

       (SELECT MIN(ROWID)FROM S_TEST GROUP BY COLUM1HAVING 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)