Re: How to select a range of records by rownum?

Hi Pao Wan,

  Please try the following:

     select rownum, ...
     from table_name 
     where rownum < 100
     group by rownum
     having rownum > 40 
     /

   Hope this helps, I find
   the KISS method works best.

      Louis Received on Mon Apr 07 1997 - 00:00:00 CDT