how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 10574 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
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
Can multiple columns be used in group by in oracle?
What are the logical operations?
What is the difference between a primary key & a unique key?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What are the different windows events activated at runtime ?
What is the best way to do multi-row insert in oracle?
What is oracle join syntax?
What are named parameters?
Can we write insert statement in function in oracle?
What is a trigger oracle?
When do we use group by clause in a sql query?
How many categories of data types?
How can we find out the duplicate values in an oracle table?
Explain an exception?
How to estimate disk space needed for an export job?
