Re: select limit of returned rows

How about
WHERE rownum > 19 AND rownum < 41

I think the engine will do all the work of retrieving all the data (especially if you have an order by and/or group by) -- so it won't save any time -- but will restrict the output.

HTH,
Tom

CyAndrew wrote:

> Hi,
> please help me with fetching only limited part of all rows. When I use
> SELECT statement and need to return only 20th to 40th row how can I reached
> that? Thanks a lot to help!
Received on Sun Jul 22 2001 - 12:52:19 CDT