Oracle Delete Duplicate Row

1.Oracle Delete Duplicate Row
In Oracle, we can delete duplicate rows by a criteria/condition:

DELETE FROM T_TB1 WHERE rowid not in (SELECT MIN(rowid) FROM T_TB1 GROUP BY C_C1, C_C2, C_C3);

***C_C1, C_C2, C_C3: list of columns that form a criteria/condition

Add Comment