select MAXIMUM(salary) from (select salary from employee order by salary

how we can find nth max salary from an employe table by
using my sql?

Question Posted / sandeep

Answer Posted / sandeep

select MAXIMUM(salary) from (select salary from employee
order by salary desc limit 'n')

n means number of rows

Is This Answer Correct ?

10 Yes

18 No

Please Help Members By Posting Answers For Below Questions

Why is mysql used?

900

How do I create a schema in mysql?

837

Is mysql a dbms?

836

Where is the mysql config file?

945

How to represent ENUMs and SETs internally?

1098

What is the difference between truncate and delete?

1132

What is latest version of mysql?

960

How to get a list of all tables in a database?

1017

What is delimiter in mysql?

825

Is postgresql better than mysql?

988

What are the differences between a primary key and foreign key?

1051

How can you make a database as your current database?

978

What is delimiter in mysql trigger?

910

How to use like conditions?

934

What is difference between inner vs self vs cross?

922