Re: Limit number of records returned in a query in 8i.

"Thomas J. Kyte" wrote:

> the way to do it is still with rownum. In 8i, you can do any query
> with it:
>
> select *
> from ( select rownum r, a.*
> from ( <YOUR QUERY GOES HERE, ORDER BYS and ALL ) A
> where rownum <= :MAXROW_TO_FETCH )
> where r >= :MIN_ROW_TO_FETCH;
>
> in that fashion you can get rows N through M or just use the inner
> query to get rows less then M
>

Thank You

-- 
Joseph P. Condle                   condle_at_mars-systems.com
Systems Analyst II                     Office
412-473-6542                
Medical ARchival Systems, Inc. (MARS)  Pager  412-572-9490
1370 Beulah Road  Pgh. Pa. 15235       Fax    412-473-6538