Re: Retrieve specified number of rows

From: Tom Best <tom.best_at_bentley.com>
Date: 2000/07/31
Message-ID: <8m4jkf$dol$1@news.bentley.com>#1/1

You can do this:

select * from (select rownum r, cola, colb from mytable order by primkey) where r between 200001 and 400000

HTH,
Tom Best

Calvin King <cking_at_sandia.gov> wrote in message news:3985CBE9.764B29CD_at_sandia.gov...
> 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