extract values ascending from a particular value

[night_scorpion]

Hello everyone ,
i would like to extract values(the next 3 values ) from a particular value ..for eg i search for a value 7 n the next 3 values should also be given out...i.e 7,8,9,10 or maybe i search for 1 and the following is displayed...1,2,3,4
1
2
3
4
5
6
7
8
9
10


is it possible
thank u in advance

[debasisdas]

Can you please post your question bit more clearly.
Please pass on few more details regarding your doubt / question.

[night_scorpion]

hi..

i have a unsorted table which contains only values.
i would like to write a query where when the user searches for a specific value (i)the next n values (whiich is also specified by the user...ie when n=2 the next 2 higher values from the specified value (i) are displayed) is given out at the output.

i hope this is clear now

thank u in advance

[debasisdas]

please post your table structure with some sample data.

[night_scorpion]

hi,
plz could u tell wht do u not understand because the sample part i have already posted above n i have explained it to my best in the next post...

thank u