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

What are the similarities between a function and a procedure?

872

What is the usage of "i-am-a-dummy" flag in mysql?

1116

What is a result set object?

936

What is 'mysqladmin' in mysql?

1010

What is data types in mysql?

900

What is relational database in mysql?

909

How do I show columns in mysql?

912

How do you rename a table?

966

How to enter boolean values in sql statements?

1112

What are the advantages of MySQL when compared with Oracle?

912

write a query to mysql in safe mode and to change the root password

945

How do I create a mysql database?

900

Give string types available for column?

973

What is regexp?

1118

What is the use of innodb in mysql?

963