Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rownum
Hi,
try this (8i):
select * from (
select rownum rank, t1.* from your_table_name t1
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