Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about SQL Query

Re: Question about SQL Query

From: nickli <ningli2000_at_hotmail.com>
Date: 15 Dec 2005 10:50:22 -0800
Message-ID: <1134672622.703021.221380@g14g2000cwa.googlegroups.com>

   Thanks for your prompt reply. I tried your solution on the following dates:

       10/5/1996, 10/6/1996, 10/10/1996

   The results I got is 2 visits, which should be 1 visit instead, since 10/5/1996 to 10/10/1996 falls within one rolling 7 day period.

   Thanks.

   Nick Received on Thu Dec 15 2005 - 12:50:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US