How to select nth max salary from employee table?
Hi All,
A favorite question for interviewer looking for sql knowledge in a candidate is
 How would you find the nth max salary of an employee?
I think there can be multiple ways of find the nth max salary of an employee from emp table.
I am throwing this question out in open to all of you to come up with all possible solutions.
Bye
Rohit
“; ; ; ;