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