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 do you login to MySql using Unix shell?

1105

Explain the difference between procedure and function in mysql?

936

What is the difference between procedure and function in mysql?

957

Can a table have multiple primary keys?

839

What is back end and front end?

853

Is mysql port 3306 tcp or udp?

877

What is a mysql view?

796

What does mysqli stand for?

876

How do I clear a mysql database?

900

How to connect html form to mysql database using php?

888

How can I see all mysql databases?

835

What is the data type for file in mysql?

927

What is myisamchk?

908

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

864

Explain about reporting services of MYSQL?

1016