Is it possible to get a previous and next out of a select statment? For instance, I have a select statement that returns certain request numbers, let's say 6, 15, 17, 22, 31. And let's say that I am currently looking at request #17. Is there any way to do a previous which should return #15 and a next which would return #22?
Thanks for any help
Thanks for any help