select max(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 / whatinaname

Answer Posted / whatinaname

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

Is This Answer Correct ?

14 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is mysql database used for?

956

What does do in mysql?

825

What is mysql root?

887

How to use count function in mysql?

889

What is index length in mysql?

885

How many TRIGGERS are allowed in MySql table?

1019

Where is mysql password stored?

873

How do you know the version of your mysql server?

1094

What is a select query?

811

How we can get the current date in mysql?

905

What does tinyint mean?

860

How do I install mysql?

840

Is mysql a database?

881

How can you change the name of any existing table by using the sql statement?

940

How do I download mysql on my laptop?

824