If you include an ORDER BY clause, and the contents of the table are not
modified, then yes. Unexpected insertion of a row in the "middle" of
the table (as ordered by your ORDER BY clause) may cause a row to be
seen twice (if it happens at an index below the point your queries have
reached) as it
Jeff,
Yes, unless the contents of the table have changed during the
'paging' sequence.
1. The SQL language specification explicitly doesn't guarantee
a particular or reproducible order on rows returned for a select
unless an ORDER BY clause is specified. How/whether order
remains the same depend