SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to delete duplicate rows in oracle and retaining last duplicate rows

780676Jun 10 2011 — edited Jun 10 2011

Hi,

I'm having millions of records in the table .Some duplicate values/rows are inserted in it.
I just want to delete duplicate rows but also want to retain the last duplicate row.
For eg if one record is found three times ,i want to delete first and second record and retain
the third one i.e the last inserted one.

Regards
Paramdeep Singh

This post has been answered by KPR on Jun 10 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2011

Added on Jun 10 2011

6 comments

17,972 views