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