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

Home -> Community -> Usenet -> c.d.o.server -> Re: Rownum

Re: Rownum

From: Klaus Zeuch <Klaus.Zeuch_at_erls04.siemens.de>
Date: 2000/06/14
Message-ID: <8i7f19$5n6$1@papyrus.erlm.siemens.de>#1/1

Hi,

try this (8i):

select * from (

select       rownum rank,  t1.*
from          your_table_name t1

order by your_column(s)
)
where rank between 20 and 30

hth

Klaus

Naguib Younes <ynaguib_at_videotron.ca> schrieb in im Newsbeitrag: D3B15.3261$D5.101655_at_wagner.videotron.net...
> Hi,
>
> Does anybody know how to return just a small set of data, ex record 20 to
 30
> in a record set, in a select statement, i used rownum, but i soon as you
 do
> an order by, it stops working, i used hints, but it stop working when the
> SQL become complicated, i'm out of ideas how to fixe this,
>
> Any help will be appreciated,
>
> Thanks in advance
>
> NY
>
>
Received on Wed Jun 14 2000 - 00:00:00 CDT

Original text of this message

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