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