Re: getting rownum 500000 - 500050 from a database

From: Wim Mortelmans <wim.mortelmans_at_ping.be>
Date: Tue, 16 Nov 1999 22:05:11 +0100
Message-ID: <80sgas$3aa$1@news3.Belgium.EU.net>

Hi Marc,

Is there no other way to identify these records? On what basis did you come up with row numbers 500000 -500050? What have they in common, a creation date,update date, username... Maybe so there can be another way to write a high performance select.

Wim
Marc Parkinson <marcpark_at_uswest.net> wrote in message news:3830B8E4.DB5D4B3B_at_uswest.net...
> I need to get row numbers 500000 through 500050 from a database.
> I also need to do an order by clause before I retreive the data.
>
> Any ideas on how to do this other then reading the fir 500000 rows of
> data??
>
>
> thanks
>
> Marc Parkinson
> marcpark_at_uswest.net
>
>
Received on Tue Nov 16 1999 - 15:05:11 CST