Semi-OT: GETNEXT methodology in SQL?

[Walter Vaughan]

Fairlight wrote:

>On Tue, Jun 09, 2009 at 08:51:49PM -0400, Dan Coutu may or may not have
>proven themselves an utter git by pronouncing:
>  
>
>>One method that jumps to mind immediately requires that you keep a
>>counter value and then use it along with a syntax like this:
>>
>>select * from mytable limit 0,1;
>>
http://en.wikipedia.org/wiki/Cursor_(databases)

One thing to remember is that you should expect a SQL database to return 
rows in a random order each time you query unless you use the "order by" 
clause.