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 the differences between lov and list item?

986

What is sharded cluster?

924

How to assign a table row to a record variable?

963

How to enter a new row into a table interactively?

957

How to create additional tablespaces for an new database?

967

Explain oracle’s server parameter file.

946

What do you mean by redo log file mirroring?

974

What is the relationship among database, tablespace and data file?

926

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2092

What is ordinary table in oracle?

1070

Explain an index?

1087

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2206

What is using clause and give example?

994

Explain the difference between a procedure and a function?

1082

What are the restrictions on external table columns?

989