delete from <<table_name>> where rowid in (select a.rowid

how to delete all duplicate records from a table using
subquery?

Question Posted / edara satish

7 Answers
23417 Views
ABC, Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / edara satish

delete from
<<table_name>>
where rowid in
(select a.rowid
from <<table_name a,table_name b>>
where a.colname = b.colname
b.colname2 = b.colname2
......
...
a.colnamen = colnamen
order by .... desired colnames)

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is primefaces used for?

1006

How to turn on or off recycle bin for the instance?

1008

What are the different types of partitions in oracle?

909

How to get a list of all user accounts in the database?

1032

How to write a query with a right outer join in oracle?

1109

What is bulk copy or bcp in oracle?

1044

What's dateware house and what's clustor with practicle example

2125

What is set verify off in oracle?

1030

How to use existing values in update statements using oracle?

1010

Can you assign multiple query result rows to a variable?

931

What are the major difference between truncate and delete?

979

Please explain joins in oracle?

1008

How data locks are respected in oracle?

1009

Can you have more than one content canvas view attached with a window ?

2261

What are the ansi data types supported in oracle?

894