I am attempting to get the 3rd highest salary of a table without using limit.
In the case of 2nd highest salary I use
SELECT salary FROM table WHERE salary < ( SELECT MAX( salary ) order by salary desc
To get the 3rd highest with the limit I use
select salary from one order by salary desc limit 3,1
So how can I get the nth salary without using limit?