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

what are archived logs?

2156

How to create a temporary table in oracle?

1216

What types of joins are used in writing subqueries?

947

In oracle there is column command, how will you explain that?

991

How to define an oracle cursor variable?

988

What is raw datatype?

1087

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5457

What is an oracle transaction?

1073

Explain the different normalization forms?

1032

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1952

What are the data types in oracle?

995

What is the data pump import utility?

991

Explain integrity constraints?

1074

What are the tools for Oracle ?

1021

What is a system tablespace?

1017