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

How do I backup mysql database on linux?

976

Can we join 3 tables in mysql?

1029

What is view in mysql?

1028

How can you count the total number of records of any table?

984

How to get nth highest salary from table in a mysql?

1000

Is mariadb better than mysql?

1105

How do I install mysql workbench?

951

How do I connect to a database in mysql workbench?

1078

what are the different tables present in mysql? : Mysql dba

1082

How we can get the current date in mysql?

1004

Is mysql a backend?

972

How can you handle the –secure-file-priv in mysql?

995

How do you use auto increment?

977

What are the differences between binary and varbinary?

1131

Does uninstalling mysql delete database?

1091