Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Newbie : Getting only limited number of rows
HI,
I have the following problem :
I want to select a limited number of rows from a table sorted on a particular set of columns. How do I structure my query to get, say Next N rows(50/100) based on the specified sort order. Limiting it by ROWNUM limits the row count and does not work as desired.
Please help.
Thanks,
Avaneesh
Received on Fri Jun 12 1998 - 00:00:00 CDT