Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Retrieve specified number of rows
I am working with a table that has about 25 million rows.
I would like to retrieve the first 200,000 rows, then the second 200,000 rows, and so forth... sorted by the primary key.
Any SQL suggestions/solutions would be much appreciated.
Calvin Received on Mon Jul 31 2000 - 00:00:00 CDT