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 -> Q: How to select 20th to 100th rows?

Q: How to select 20th to 100th rows?

From: Amit Bhati <amit_at_visi.com>
Date: 1997/08/14
Message-ID: <5t009a$1rc$1@darla.visi.com>#1/1 








Say, I have a table with 1000 records in it. I have two numbers, x = 25
and y = 250. I want to select the 26th. to 250th. rows of this table. 



In SQL how can I do this without using a SEQUENCE column in the table?



E-mailed replies much appreciated. Thanks,


--
amit bhati


Received on Thu Aug 14 1997 - 00:00:00 CDT












Original text of this message













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