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

What is join in mysql? What are the different types of join?

933

What port is mysql running on?

940

Where is mysql used?

1001

How large can a mysql database become?

1004

Which software is used for mysql?

985

How to rename an existing table in mysql?

1035

How many sql dml commands are supported by 'mysql'?

974

What does the file with the extension: frm, myd, and myi contain?

926

How can you change the password of a mysql user?

966

Is mysqli secure?

900

What is difference between mysql mysqli and pdo?

943

What is the role of a limit in a mysql query?

1009

Which datatype is used for email in mysql?

960

What are the steps involved in query processing?

888

What is text in mysql?

916