Results 1 to 2 of 2
Feb 3, 2011, 01:08 #1
- Join Date
- Sep 2010
- 0 Post(s)
- 0 Thread(s)
how to find nth highest salary from emp table?
Most of the times it is common interview question in database interview that
How to find 2nd highest salary ?
How to find 3rd highest salary?
and so on
So I want one query where i will just change the number like 1, 2, 3, 4 and i'll get the highest salary.