delete from abc where rowid not in (select max(rowid) from abc group by co

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

Question Posted / maninder

Answer Posted / maninder

delete from abc where rowid not in (select max(rowid) from
abc group by column_name_with_dup.values.);

Is This Answer Correct ?

10 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Explain temporal data types in oracle

605

What are the uses of synonyms?

603

Explain the use of constraints option in exp command.

558

How much memory your 10g xe server is using?

578

what are the advantages of running a database in archive log mode?

1729

How does oracle handle read consistency?

674

How to put more than 1000 values into an oracle in clause?

583

Explain alias?

705

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

1782

What is a subquery in oracle?

574

How to create a stored program unit?

578

What is a schema in oracle?

539

How to calculate date and time differences in oracle?

528

Explain the use of owner option in exp command.

567

List out the types of joins.

591