Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Rownum
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 Tue Jun 13 2000 - 00:00:00 CDT