> Well, it makes sense if he includes an order by clause. But thereI think it's not about the displaying records 50,000 to 50,010, but
> is no way to determine the desired records in that case other than
> determining at least the first 50,010 records. So, the
> "first...skip" solution is as good as possible.
rather about scrollable cursors and operations related to them
(first(), last(), absolute(n), etc.).
So we are back to the discussion "Scrollable cursors: to be or not to
be". Can anobody tell do Oracle, DB2 and MS SQL implement them and how?