I need to select the records which r not in a Sequential dates.

Like

ID Start_date End_date Sq.no

1 01-01-2001 03-15-2001 1
1 03-15-2001 05-31-2001 2
1 05-31-2001 06-30-2001 3

2 01-01-2001 02-20-2001 4
2 02-10-2001 03-25-2001 5
2 03-25-2001 04-20-2001 6



I am trying to select the records, the dates are not in ORDER like ID 2
The End_date can’t be Greater then Start_date

Like ID 2 02-10-2001 (Sq.no 5)
it’s greater then the 02-20-2001 Sq.no 4

it should be equal to or after the 02-20-2001.

Every Start_date should be start after the End_date for every ID.

Pl. help for finding the records which r not in a Sequence(date) ORDER.


thanks in advance