1.

How Will You Delete Duplicating Rows From A Base Table?

Answer»

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.
where rowid <(select MIN(rowid) from table_name TB where ta.dv=tb.dv); 

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.
where rowid <(select min(rowid) from table_name tb where ta.dv=tb.dv); 


Discussion

No Comment Found

Related InterviewSolutions