On 2005-08-26, premgoel@gmail.com <premgoel@gmail.com> wrote:
>
>
> I have a table
>
> person_id start_month end_month
> 1 200301 200303
> 1 200302 200303
> 1 200303 200304
> 1 200306 200308
>
>
> For the first 3 records, the end_month of the previous record is less
> than the start_month of the next record. I want to write a SQL to
> combine them and give me the following result
>
> person_id start_month end_month
> 1 200301 200304
> 1 200306 200308


What makes the first 3 records be the first three records?




--
Rene Nyffenegger
http://www.adp-gmbh.ch/