> Well, it makes sense if he includes an order by clause. But there
> 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.

I think it's not about the displaying records 50,000 to 50,010, but
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?

Roman