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

What is required to create mysql database?

997

What is use command in mysql?

1053

Define REGEXP?

1112

How do I find mysql version in mysql workbench?

949

How to show all tables with 'mysql'?

1015

How to insert html code into mysql database using php?

1081

What is triggers and how it can be used in mysql?

983

How do I connect to a database in mysql workbench?

1038

How show all tables in mysql query?

947

What is 'mysqldump'?

1077

How to enter Characters as HEX Numbers?

1025

What is row level locking in access?

901

What is a csv table?

1014

How do I start mysql in mysql workbench?

957

What is mysqli_select_db?

979