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: subtracting values of sequential rows

Re: subtracting values of sequential rows

From: <mh_at_pixar.com>
Date: Mon, 20 Aug 2007 05:25:29 GMT
Message-ID: <dB9yi.2340$LL7.297@nlpi069.nbdc.sbc.com>


sybrandb_at_hccnet.nl wrote:
> You need analytical functions, in particular the LAG function.

Thanks Sybrand, that does the trick.

> The LAG function is documented in the datawarehousing manual.
> Other than that you can wait for Michel Cadot to do your work for you.

Not necessary, although I've been the beneficiary of Michel's posts numerous times... Thanks Michel!

-- 
Mark Harrison
Pixar Animation Studios
Received on Mon Aug 20 2007 - 00:25:29 CDT

Original text of this message

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