This is a FAQ. There is no such thing in relational databases as the first
500 rows. Define "first".
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Michael" <melliott42_at_yahoo.com> wrote in message
news:91721cf.0408171304.50618189_at_posting.google.com...
> Hello,
>
> In Oracle 8.17 from SQLPLus how can I SELECT the first 500 rows of a
> table? I am versed in creating (filtering out) data using a WHERE
> clause - this is different than that.
>
> I ideally would like to SELECT the first 500 records of a table then
> the NEXT 500 and so forth.
>
> Thanks for your advice,
>
> Michael
Received on Tue Aug 17 2004 - 16:17:08 CDT
