Oracle Doppelte Einträge löschen.

DELETE FROM Tabellename
WHERE ROWID IN
(
 SELECT ROWID
 FROM
  (
   SELECT ROWID, ROW_NUMBER()
   OVER (PARTITION BY Spalte1, Spalte2, Spalte3, Spalte4 ORDER BY Spalte1) DUP
   FROM Tabellename
  )
 WHERE DUP > 1
);
    

Kopieren