title: How to fetch the nth highest salary from a table without using TOP and sub-query?
body: <p>Recently in an interview I was asked to write a query where I had to fetch nth highest salary from a table without using TOP and any sub-query ?</p>
  
  <p>I got totally confused as the only way I knew to implement it uses both TOP and sub-query.</p>
  
  <p>Kindly provide its solution.</p>
  
  <p>Thanks in advance.</p>