This discussion is archived
8 Replies Latest reply: Dec 3, 2012 12:05 AM by 910113 RSS

SELECT next value in table

754749 Newbie
Currently Being Moderated
I need to select the next id in a table where the id is a certain value:

SELECT NEXT(FORM_ID) FROM LOCAL_FORM_DATA WHERE FORM_ID = 2

This obviously doesn't work, but is there a way to do it?

This would output whatever the next ID would be. The ID's may not exist so I can't just add 1 to it.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points