Re: finding continuous range

From: Mikito Harakiri <nospam_at_newsranger.com>
Date: Sat, 12 May 2001 01:14:27 GMT
Message-ID: <T70L6.2300$j65.184967@www.newsranger.com>

I apologyse for replying to wrong message: my newsreader displays only a subset of google.

Given the data:

SEQNUM STARTDATE ENDDATE MWT
---------- ---------- ---------- ----------

1          01-JAN-01  01-FEB-01  40
1          20-JAN-01  05-FEB-01  40
1          15-FEB-01  20-MAR-01  40
1          20-MAR-01  25-MAR-01  40

Your query returns:

SEQNUM STARTDATE ENDDATE MAX(S3.MWT
---------- ---------- ---------- ----------

1          01-JAN-01  19-JAN-01  40
1          20-JAN-01  01-FEB-01  40
1          31-JAN-01  01-FEB-01  40
1          04-FEB-01  05-FEB-01  40
1          15-FEB-01  19-MAR-01  40
1          24-MAR-01  25-MAR-01  40

I run the one that you suggested the second time (with two auxiliary views). I don't see interval (01-JAN-01, 05-FEB-01) in the output... Received on Fri May 11 2001 - 20:14:27 CDT