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 -> Re: SELECT

Re: SELECT

From: Uli Herberg <ulrich.herberg_at_lrz.tu-muenchen.de>
Date: Fri, 21 Sep 2001 14:29:34 +0200
Message-ID: <9ofbq3$7ht$1@wsc10.lrz-muenchen.de> 





"Davide Bianchi" <davidebianchi_at_davidebianchi.net> schrieb


> select * from tablename where ROWNUM >= 11 AND ROWNUM <= 20;




Strange, that works for ROWNUM >= 1 AND ROWNUM <= 11,
but I don't get any entries when using  ROWNUM >= 11 AND ROWNUM <= 20



Believe me, there are enough rows in the table!



Regards,


Uli
Received on Fri Sep 21 2001 - 07:29:34 CDT












Original text of this message













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