Re: how to display partial results from a query (effectively)

From: Sharkie <sharkdba_at_yahoo.com>
Date: 30 Oct 2002 11:53:11 -0800
Message-ID: <423b5ab1.0210301153.44dc015e@posting.google.com>

Thanks for the query as well as the link (asktom.oracle.com) Great site!

jocave_at_yahoo.com (Justin Cave) wrote in message news:<233b7a65.0210291510.7b27d68f_at_posting.google.com>...

> The easiest way to do this would be a query along the lines of
>
> select *
> from ( select a.*, rownum rnum
> from ( YOUR_QUERY_GOES_HERE -- including the order by ) a
> where rownum <= MAX_ROWS )
> where rnum >= MIN_ROWS
>
> (code shamelessly borrowed from the asktom article here
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:127412348064)
Received on Wed Oct 30 2002 - 13:53:11 CST