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

Whats the benefit of dbms_stats over analyze?

2005

What is dual table oracle?

987

What is an oracle function?

1170

What is the usage of merge statement?

1154

How to select some columns from a table in oracle?

1097

What is the difference between view and materialized view in Oracle?

1156

what is port in oracle? how is it related to database application.

1949

How would you change old and new values in an insert, delete and update triggers?

1022

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1999

What do you mean by redo log file mirroring?

1035

State and explain about oracle instance?

1000

How to install oracle odbc drivers?

1093

What is the fastest query method to fetch data from the table?

1366

Hi Can any one tell me what are the API's used in requisition import.

1924

What is concurrency in oracle?

1009