Re: Returning Row 20 to 29

On Thu, 19 Feb 1998 08:53:41 +0100, Stephan Schaefer <stephan.schaefer_at_camline.com> wrote:

>Huy V. Le wrote:
>
>> But let say you want to do a second query that will return row 20 to
>> 29.
>
>select
> col1,col2
>from
> ( select
> rownum n,col1,col2
> from
> mytable
> )
>where
> n between 20 and 29
>;

D'ohh....how did I overlook that? :-)

You'll want to be careful using something like that, though....no way to guarantee the row order will be the same from query to query.

/cpk Received on Thu Feb 19 1998 - 00:00:00 CST