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

Is there a free mysql?

907

What is slow query log in mysql?

1110

In which language mysql has been written?

1338

Why are function needed?

946

Can you tell how to find the number of rows in a resultset using php?

904

What is csv?

953

How to see the create table statement of an existing table?

1054

How do I rename a table in mysql workbench?

966

What is ibdata1?

917

What is indexing in mysql?

967

How can you take the backup and restore a mysql database using php?

962

what is constraints? Also explain the different types of constraints?

974

What is the return type of mysqli_query?

869

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

932

What is the difference between truncate and delete?

1198