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

What is a Garbage Collection? and what is full recursive Garbage collection?

2861

Why do you use stored procedures and state some of its disadvantages?

980

Explain an exception and its types?

1026

How to insert a new row into a table in oracle?

1108

How to increment dates by 1 in oracle?

1009

Explain oracle 12c new features for developers?

1003

How to run create database statement again?

1089

How to open a cursor variable?

985

How to load excel data sheet to oracle database

979

What are the different oracle database objects?

1037

How to change system global area (sga) in oracle?

967

Explain the use of grant option in imp command.

965

How to connect the oracle server as sysdba?

1023

What are the different types of partitions in oracle?

921

What is bulk load in oracle?

1015