Remove Date overlap duplicates

From: Shank... <willbecreated_at_gmail.com>
Date: Sun, 4 Oct 2009 23:11:14 -0700 (PDT)
Message-ID: <22c647e6-f687-4ea1-9991-9fc9102fe760_at_x6g2000prc.googlegroups.com>



Hi,

I have a table containing following data.

ID   Start_date         End_date
1    20-OCT-2005     31-DEC-2005
1    01-NOV-2005    31-JAN-2006
2    01-JAN-2005     31-JAN-2005
2    01-JAN-2005     31-DEC-2006

Now I need to update the start date of 2nd Row as '01-jan-2006' and I also need to delete the 3rd row.
In a nut shell, I need to remove the duplicate data either by updating or by deleting.
Is there any way to do it using PL/SQL? Received on Mon Oct 05 2009 - 01:11:14 CDT

Original text of this message