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
23712 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

How to execute a stored procedure in oracle?

1075

How to view existing locks on the database?

1044

What are dml statements in oracle?

1087

How to initialize variables with default values?

1226

What are the different types of partitions in oracle?

964

Explain the different normalization forms?

1069

How do I manually uninstall oracle client?

1079

How to see free space of each tablespace?

1032

How to use an explicit cursor without open statements?

1048

What is the usage of synonyms?

1133

Explain integrity constraint?

1155

What is a cursor in oracle?

1166

How to find the duplicate rows count from employees table in oracle?

1075

What is difference between sid and service name in oracle?

949

What is archive log in Oracle?

1127