Home » SQL & PL/SQL » SQL & PL/SQL » Can any one help to remove duplicate rows in a table (11.1.0.7)
Can any one help to remove duplicate rows in a table [message #647889] Thu, 11 February 2016 00:11 Go to next message
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.
Re: Can any one help to remove duplicate rows in a table [message #647890 is a reply to message #647889] Thu, 11 February 2016 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I followed syntax however it is not deleting records.


Which syntax?

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

This is a FAQ, please have a look at OraFAQ and How does one eliminate duplicate rows from a table.



Re: Can any one help to remove duplicate rows in a table [message #647948 is a reply to message #647889] Fri, 12 February 2016 06:59 Go to previous messageGo to next message
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
);
Re: Can any one help to remove duplicate rows in a table [message #647949 is a reply to message #647948] Fri, 12 February 2016 07:22 Go to previous message
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 Mar 28 14:08:25 CDT 2024