select MAXIMUM(salary) from (select salary from employee order by salary

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

Question Posted / sandeep

Answer Posted / sandeep

select MAXIMUM(salary) from (select salary from employee
order by salary desc limit 'n')

n means number of rows

Is This Answer Correct ?

10 Yes

18 No

Please Help Members By Posting Answers For Below Questions

How to delete a column and add a new column to database

892

What are the disadvantages of mysql?

1006

Why we use mongodb instead of mysql?

923

How many TRIGGERS are allowed in MySql table?

1019

What is key in mysql?

835

How to show all tables with 'mysql'?

951

What is indexing in mysql?

879

What is 'mysqldump'?

987

How does mysql encrypt passwords?

847

1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

1951

What is mysql default database?

907

What are the 'mysql' command line arguments?

948

How many columns can you create for an index?

903

What is the current mysql version?

946

What is the latest mysql version?

928