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