Take for instance I have a record ID of 9.
On a website, I want to navigate to the next record. Now obviously the website could take the current ID and add 1 to it however that record may not even exist therefore there is nothing to display.
So, what is the best way in SQL to say "here is a record ID, go find me the next one from this ID" and return back that ID?
yes, there is a table with all records that I would be querying from - I just need to know what approach/syntax to use to ask SQL to bring me back the next record up given an ID to it.