Start and End Dates check
590587Nov 17 2009 — edited Nov 20 2009Hi,
I have a requirement to find the list of persons who have overlapping dates.
Each person can have many start and End Dates, but only one row that has a NULL end date, the active record. If the start and end dates are overlapped, like in the example below, the second row should have a start date of 24-DEC-2006 and not 22-DEC-2006. Is it possible to list those persons who have overlapping dates/gap in the dates.
Empl_ID Start Date End Date
12345 01-JAN-2006 23-DEC-2006
12345 22-DEC-2006 13-JAN-2007
12345 14-JAN-2007 NULL
Any help is greatly appreciated.
Thanks!