From: boston103@hotmail.com   
      
   select *   from   
     ( select t1.*, rownum rn from ( select * from t1 order by x ) t1   
        where rownum <= upper_limit )   
    where rn >= lower_limit;   
      
      
   "¢Ð¢ý¢ö" <@.@> wrote in message news:bpc5i8$khq10@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   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)