title: How to find n'th highest value of a column?
body: <p>Is there a command akin to:</p>
  
  <ul>
  <li><p><code>2nd highest salary from tbl_salary</code> or</p></li>
  <li><p><code>4th highest salary from tbl_salary</code> ?</p></li>
  </ul>
  
  <p>I've seen:</p>
  
  <pre><code>select salary
  from tbl_salary t
  where &amp;n = (
      select count(salary) 
      from(
          select distinct salary
          from tbl_salary
      )where t.salary&lt;=salary
  );
  </code></pre>
  
  <p>How does this it works?</p>
  
  <p>Are there other simple ways to get result?</p>