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!

Delete the data based on last updated date

800849Apr 22 2012 — edited Apr 22 2012

Hi ,

I have sample data like below.I want to delete the duplicate record but want to keep the latest record in the table.

Assumptions:-- There are milion of records so I do not know the last_updated_date for the duplicate record

EMP_NUMBER LAST_UPDATE_DATE

555954116 12/2/2008 9:28:54 PM
555954116 9/7/2008 5:16:27 AM
555954116 9/7/2008 5:16:27 AM
555954116 9/7/2008 5:16:27 AM
555954116 9/7/2008 5:16:27 AM
555954116 9/7/2008 5:16:27 AM
555954116 9/7/2008 5:16:27 AM

Please suggest some idea.

Regards
Das

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2012

Added on Apr 22 2012

5 comments

732 views