oracle rownum

From: odelya <be.special_at_gmail.com>
Date: Tue, 21 Aug 2007 07:11:03 -0700
Message-ID: <1187705463.959604.54720@k79g2000hse.googlegroups.com>

Hi,

I have a question about rownum which is not mentioned.

Lets say that I want to extract a 3 records out of a result where the middle one is the query.
For example:
I have records:
ID Value

1	Hello
2	Hi
3	Wow
4	Shrek
5	Shus
6	What?

And I need a query that by receiving ID, it will extract the record with the id and the previous one to that and the next one. For example for selecting ID=4, it will return records: 3,4,5.

Is there a way to do it in Oracle? Received on Tue Aug 21 2007 - 09:11:03 CDT