Re: OFFSET function in oracle

select * from
  ( select t1.*, rownum rn from ( select * from t1 order by x ) t1

     where rownum <= upper_limit )
 where rn >= lower_limit;

"¢Ð¢ý¢ö" <_at_.@> wrote in message news:bpc5i8$khq10_at_imsp212.netvigator.com...
> I want to retrieve a range of record
> such as retrieving 11th to 20th records from 10000 records
> In SQL Server, i can use the "OFFSET" function.
> so i wanna ask does Oracle provide any function similar to "OFFSET" in SQL
> SERVER?
>
>
>
> Thanks in advance
> Regards
> Bun
>
>
Received on Fri Nov 21 2003 - 15:36:37 CET