Re: Look ahead 2 rows

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: 2000/08/11
Message-ID: <8n16re$9vb$1@news.inet.tele.dk>#1/1

Hi Craig.

If you've got Oracle 8i Release 2 (8.1.6) there's now analytical functions to do exactly that, check out LAG and LEAD.

HTH. Finn

craibuc <craibucNOcrSPAM_at_hotmail.com.invalid> wrote in message news:05986872.0b958be7_at_usw-ex0105-035.remarq.com...
> When processing a cursor, I need to look ahead two rows from the
> current row to compare values. What's the syntax for doing this?
>
> Craig Buchanan
> Cogniza, Business Intelligence Specialists
> www.cogniza.com
> +1.612.824.5858
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Fri Aug 11 2000 - 00:00:00 CDT