Reply to comment
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.