Re: Returning Row 20 to 29

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
;

Stephan Schaefer
stesch_at_camline.com Received on Thu Feb 19 1998 - 00:00:00 CST