can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
I think Daleep answer is not so precise, if you want 3rd or ny specified answer, this only can only be seems right for 2nd highest salary, else, its not optimise query.I found Preeti's query more optimistic and accurate.