how to find find & delete duplicate rows from two different
tables?
Answer Posted / pravin jadhav
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);
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to use values from other tables in update statements using oracle?
various types of hints and their usage
How to use "in out" parameter properly?
How to grant create session privilege to a user in oracle?
What is a tns file?
How to define a data source name (dsn) in odbc manager?
What is the scope of a local variable?
State all possible different index configurations a table can possibly have?
How to execute the package in oracle?
Is there a function to split a string in plsql?
what are the advantages of running a database in archive log mode?
Explain rename?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What is program global area (pga) in oracle?
How to convert numbers to characters in oracle?