title: How to get Nth big item
body: <p>I am getting 11th older person from users table with the following SQL statement</p>
  
  <pre><code>select MAX(age) 
  from ( select * 
         from (select * 
               from users 
               order by age asc)  
         where rownum &lt;12)
  </code></pre>
  
  <p>is there a simplified and efficient query to get 11th older person with full information?</p>
  
  <p>USING 
  Oracle 11G</p>