Deleting Duplicates

Table of Contents

1. Delete Duplicates

Chapter 1. Delete Duplicates

delete from  where rowid in (
    SELECT  rowid FROM
    group by rowid , col1, col2 , col3
    minus
    SELECT  min(rowid) FROM  , col1, col2 , col3

This will be much faster than
DELETE FROM EMP E
  WHERE E.ROWID > ANY (SELECT ROWID
  FROM EMP M
  WHERE M.EMPNO = E.EMPNO
  AND M.ENAME = E.ENAME
  AND M.JOB = E.JOB );