SQL & PL/SQL

Hi,

I'm trying to extract some data from a table 65000 rows at a time (to fit each extract into XLS)

This query returns just over 800,000 rows

select *
from serial_number
where site_id = 'NDC01'

My first query works fine and returns 65000 rows.

select *
from serial_number
where site_id = 'NDC01'
and rownum between '1' and '65000'

However my second query doesn't return any rows at all

select *
from serial_number
where site_id = 'NDC01'
and rownum between '65001' and '130000'

I can understand why, as the results for the second query will return 65,000 rows, therefore the rownums will be reset to between '1' and '65000'

Any ideas how I can extract the data I am looking for?


Thanks,

SM.