Re: oracle rownum

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 21 Aug 2007 17:28:56 +0200
Message-ID: <46cb04ba$0$228$e4fe514c@news.xs4all.nl>

"Thomas Kellerer" <FJIFALSDGVAF_at_spammotel.com> schreef in bericht news:5j0dshF3ro3guU1_at_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

Right, that's what I was looking for but could not find anymore!

Shakespeare Received on Tue Aug 21 2007 - 10:28:56 CDT