select salary from tablename order by desc limt 4;

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed Questions by Altaf Hussain Sayyed

• Jun 29th, 2011

Suppose we have to find records in the emp_salary table with nth highest value for salary.select * from emp_salary whare salary in(select distinct salary from emp_salary order by salary desc limit n-1,1);

Siva Krishna Yarlagadda

 Profile Answers by Siva Krishna Yarlagadda Questions by Siva Krishna Yarlagadda

• Apr 3rd, 2011

Select salary form employee order by salary desc limit 1,13rd Highest Salary-->Change Limit 2,14th highest salary-->change Limit 3,1

Answer Question  Select Best Answer