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

Home -> Community -> Usenet -> c.d.o.misc -> getting rownum 500000 - 500050 from a database

getting rownum 500000 - 500050 from a database

From: Marc Parkinson <marcpark_at_uswest.net>
Date: Mon, 15 Nov 1999 18:52:36 -0700
Message-ID: <3830B8E4.DB5D4B3B@uswest.net> 





I need to get row numbers 500000 through 500050 from a database.
I also need to do an order by clause before I retreive the data.



Any ideas on how to do this other then reading the fir 500000 rows of
data??




thanks



Marc Parkinson


marcpark_at_uswest.net


Received on Mon Nov 15 1999 - 19:52:36 CST












Original text of this message













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