How will you delete duplicating rows from a base table?
ORACLE Interview Questions and Answers (Part 4)
(Continued from previous question...)
547. How will you delete duplicating rows from a base table?
delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); or
delete duplicate_values_field_name dv from table_name ta where rowid <(select min(rowid) from table_name tb where ta.dv=tb.dv);
(Continued on next question...)
Other Interview Questions
|