Fatih Keles wrote:
Actually I think you can use the top-N query to get the value you want e.g. I have a table called EMPLOYEES, and I want the 3rd highest SALARY:
But if you're on Oracle, then you should try the analytical functions as Martin suggests. They're more flexible and you will learn something new.