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 ); |
||
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 ); |
||