Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Retrieve specified number of rows

Retrieve specified number of rows

From: Calvin King <cking_at_sandia.gov>
Date: 2000/07/31
Message-ID: <3985CBE9.764B29CD@sandia.gov>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US