title: To fetch ALTERNATE records from a table.
body: <p>I have two table emp1 and emp2 and i want to fetch the alternate records from the table like odd and even and 3rd Max Salary of Emp</p>
  
  <blockquote>
    <p>table like emp1</p>
  </blockquote>
  
  <pre><code>empno empname empposition
  1     abc     Manager
  2     cef     Clark
  3     xyz     Supervisor
  4     pqr     Peon
  5     hij     Senior Manager
  </code></pre>
  
  <blockquote>
    <p>table like emp2</p>
  </blockquote>
  
  <pre><code>empno empname empsalary
  1     abc     25,000
  2     cef     15,000
  3     xyz     10,000
  4     pqr     5,000
  5     hij     35,000
  </code></pre>