Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rownum
I know that this works in 8i but not in 8.0.5, any ides for 8.0.5?
NY
Klaus Zeuch <Klaus.Zeuch_at_erls04.siemens.de> wrote in message
news:8i7f19$5n6$1_at_papyrus.erlm.siemens.de...
> 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