select salary from employee order by salary desc limit n-1, 1

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

Question Posted / pious deepak

Answer Posted / pious deepak

select salary from employee
order by salary desc limit n-1, 1

Is This Answer Correct ?

29 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to install mysql?

981

How is data stored in mysql?

884

How do I flush privileges in mysql?

959

How to use case expression?

915

What is the use of mysql_close()?

947

What is acid in mysql?

817

What is mysqli_num?

900

How many columns can be used for creating Index?

999

What is the password of mysql?

930

Do while loop in mysql procedure?

1035

How do I install and use mysql?

902

How do I run mysql from command line?

1000

What is the hostname for mysql database?

971

What is the default port of mysql server?

988

How many rows can be inserted in mysql at a time?

981