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

Home -> Community -> Usenet -> c.d.o.server -> Re: Analytical Function: select last value that is not null

Re: Analytical Function: select last value that is not null

From: Marcel Kraupp <marcel.kraupp_at_gmx.ch>
Date: 13 May 2002 04:05:39 -0700
Message-ID: <332bb004.0205130305.7f1f850c@posting.google.com> 





Whow....



Elegantly solved, indeed.... almost magical.
Thanks a lot to everyone who suggested a solution. 



MK




> How about:

> 

> SELECT d,

>        SUM(n) over (PARTITION BY f) status   

>   FROM (


> SELECT x.*,

>        SUM(n) over (ORDER BY d) f

>   FROM x ) v

>  ORDER BY d

> 

> 

> I LOVE analytical functions!!!

Received on Mon May 13 2002 - 06:05:39 CDT












Original text of this message













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