DELETE FROM T1 WHERE ROWID IN (SELECT ROWID FROM T1 WH

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

Question Posted / noor

Answer Posted / noor

DELETE FROM T1
WHERE ROWID IN (SELECT ROWID FROM T1
WHERE ROWID NOT IN(SELECT MAX(ROWID) FROM
T1 GROUP BY C1,C2));

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How many types of segments in Oracle?

632

What is the difference between 10g OEM and 11g OEM?

628

How to find out what oracle odbc drivers are installed?

672

How many types of cluster table in Oracle?

665

What is rich query?

633

What is rowid and rownum in oracle?

622

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

1942

How to use "in" parameter properly?

705

What is a subquery in oracle?

663

Differentiate between post-database commit and post-form commit?

621

What are the different types of failures that occur in Oracle database?

697

What are the four Oracle system processes that must always be up and running for the database to be useable?

672

Can I create users through internet explorer in oracle 10g?

658

How to delete a user account in oracle?

637

What is the difference between truncate & delete command?

710