delete from table_name where rowid not in (select max(rowid) from table gro

how to find find & delete duplicate rows from two different
tables?

Question Posted / pravin jadhav

3 Answers
11779 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

Please Help Members By Posting Answers For Below Questions

How to loop through data rows in the implicit cursor?

1066

Explain the blob datatype?

1069

What is primefaces used for?

1045

What are data pump export and import modes?

1058

What is define in oracle?

1056

What is blob data type in oracle?

1112

What is a sub query? What are its various types?

1164

Explain an exception and its types?

1068

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2205

Explain integrity constraint?

1155

How to use "in out" parameter properly?

1042

How to delete all rows a table in oracle?

1065

what is the dual table in oracle?

987

What is background process in Oracle?

1097

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2349