Re: select limit of returned rows

On Fri, 20 Jul 2001, pohoda_at_seznam.cz 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!

Tom Kyte has an answer.

http://asktom.oracle.com/pls/ask/f?p=4950:8:28371::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:555422909506,{rownum}

-- 
Galen Boyer
It seems to me, I remember every single thing I know.