Hi everyone,
Just say I'm doing a select ... from ... where ... order by...
I know the row I want, but I also want the row after (or before in another
case), and the row I want is NOT at the top/bottom of the order by :(.
Is there a way to do it faster than doing the entire select?
The reason I have this is because I'm letting the user choose the order of
the query. When viewing information based on a particular row, I want to
put a "Next" and/or "Prev" button to go to view information based on the
next/prev row in the order previously selected, and so on...
Storing the query results into a temporary location is starting to look
like the way to do it. But as this is a web application, deciding the
optimal solution to when and how to delete the results is not easy for me :(.
Thanks!
Link.