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: oracle rownum

Re: oracle rownum

From: Thomas Kellerer <FJIFALSDGVAF_at_spammotel.com>
Date: Tue, 21 Aug 2007 17:15:29 +0200
Message-ID: <5j0dshF3ro3guU1@mid.individual.net> 





odelya wrote on 21.08.2007 16:38:


> Well,

> But the ids are not seqeuntial - it can verify from each record..

> For exampe:

> ID Value

> 225       Hello

> 228       Hi

> 258       Wow

> 240       Shrek

> 259       Shus

> 230     What?

> 




I think this should be possible using the LAG() function. Check out the section 
about analytical functions in the manual.



Thomas
Received on Tue Aug 21 2007 - 10:15:29 CDT












Original text of this message













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