Re: finding continuous range
Date: Sat, 12 May 2001 01:14:27 GMT
Message-ID: <T70L6.2300$j65.184967_at_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
 
Your query returns:
 
SEQNUM     STARTDATE  ENDDATE    MAX(S3.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
---------- ---------- ---------- ----------
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 Sat May 12 2001 - 03:14:27 CEST
