select salary from employee e1 where (n-1)=(select count(*) from employee

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

Question Posted / sumit

Answer Posted / sumit

select salary from employee e1
where (n-1)=(select count(*) from employee where
salary>e1.salary)

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why MySQL is used?

1037

How to declare variable in mysql trigger?

1017

How do you shutdown a mysql database?

1056

What is delimiter in mysql trigger?

961

How to store binary data in mysql?

1003

Is sql and mysql same?

937

Why do we need mysql?

978

Where does mysql store data?

884

How do I run mysql?

1015

How do I select a database in mysql workbench?

1018

What is the use of pdo?

955

What is the difference between the primary and unique key in mysql?

985

Define REGEXP?

1110

What is the use of mysql_fetch_array () function in php?

941

What is pragma exception?

974