How to select nth max salary from employee table?

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

“; ; ; ;