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 the function of mysqldump?

1074

How do I find mysql database?

916

Is oracle mysql free?

891

Is mysql a dbms?

896

How do you concatenate strings in mysql?

1007

How to create a trigger in mysql?

940

How to check if a record exists in a mysql database php?

893

What is the return type of mysqli_query?

869

using primary can we relate two table, with out foreign key?

2717

What is procedure in mysql?

940

How do you know the version of your mysql server?

1179

What are Heap tables?

1571

What is the difference between char and varchar in mysql?

1121

Where the database is stored in mysql?

970

How do I install the latest mysql on ubuntu?

993