Re: Finding a date

xaf_at_tekano.fr (XaFTek) wrote in message news:<1011570f.0210230850.4a597b8f_at_posting.google.com>...
> Hi !
>
> I have a table named
> checklog
> (
> checklogdate date not null,
> idapp integer not null
> )
>
> By example for idapp=10
> I have thoses lines in the table (date format is DD/MM/YY):
> 20/10/02 10
> 12/10/02 10
> 10/10/02 10
> 09/10/02 10
> 06/08/02 10
> 05/08/02 10
> 04/08/02 10
> 02/08/02 10
> 01/08/02 10
> 30/06/02 10
>
> There is only 1 line by day for an idapp.
>
> Starting down from the date 12/10/02 I want to know when my checklog
> "start record".
> Start record is where checklog began to record my idapp within a 7
> days no recording gap.
>
> For this example I have a session recording form 09/10/02 to 12/10/02
> because there is more than 7 days between 09/10/02 and 06/08/02.
> I have also a session recording from 06/08/02 to 01/08/02.
>
> How can I do that in SQL ?
>
> Thank's in advance.

If you can use analytical function (8.1.5+ I think):

select curr
from (
select checklogdate curr, lag(checklogdate ) over ( order by checklogdate ) prev from checklog )
where curr - prev > 7
/ Received on Wed Oct 23 2002 - 22:41:12 CDT