OraFAQ Forum: SQL & PL/SQL » Can any one help to remove duplicate rows in a table

Home » SQL & PL/SQL » SQL & PL/SQL » Can any one help to remove duplicate rows in a table (11.1.0.7)

Thu, 11 February 2016 00:11

kerneltraining
Messages: 1
Registered: February 2016
Location: Hyderabad

Junior Member

Please help how to delete the duplicate rows in a table of 1 lakh records. I followed syntax however it is not deleting records.

Thu, 11 February 2016 00:59

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I followed syntax however it is not deleting records.

Fri, 12 February 2016 06:59

varlamovvp
Messages: 13
Registered: February 2016
Location: Russia

Junior Member

delete from my_table
where rowid NOT IN (
  select max(rowid) from my_table group by unique_field
);

Fri, 12 February 2016 07:22

Bill B
Messages: 1971
Registered: December 2004

Senior Member

And since we can't see your screen, what happened (or you can cut and paste the session)

Previous Topic:	Materialised view refresh on commit
Next Topic:	What is the switching context with FORALL?

Goto Forum:

]

Current Time: Thu Jun 25 21:09:05 CDT 2026