rnouk" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Friday, April 27, 2001 12:37 PM
>Subject: Re: Viewing data from the previous row
>
>
> > Roger Karnouk wrote:
> > >
> > > Is it possible in a Select query to get values from the previous
ECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 27, 2001 12:37 PM
Subject: Re: Viewing data from the previous row
> Roger Karnouk wrote:
> >
> > Is it possible in a Select query to get values from the previously read
row
> > in order to do things like cumulative sum
Roger Karnouk wrote:
>
> Is it possible in a Select query to get values from the previously read row
> in order to do things like cumulative sums or other formulas which require
> the previous value in order to calculate the current value.
>
> ex.
> day current sales cumu_total
> - --
Is it possible in a Select query to get values from the previously read row
in order to do things like cumulative sums or other formulas which require
the previous value in order to calculate the current value.
ex.
day current sales cumu_total
- ---
1