delete from Table_Name a
where
a.rowid >
any (select
b.rowid
from
Table_Name b
where
(A.column_name_1
= B.column_name_1)
and
(A.column_name_2
= B.column_name_2)
);
commit;
Example: Student
table have three column id, name and age. We want to delete duplicate for same id
and name
delete from student a
where
a.rowid >
any (select
b.rowid
from
student b
where
(A.id
= B.id)
and
(A.name
= B.name)
);
commit;
|