select max(salary) from employee order by salary desc limit n-1, 1

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

Question Posted / whatinaname

Answer Posted / whatinaname

select max(salary) from employee
order by salary desc limit n-1, 1

Is This Answer Correct ?

14 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to use sum function in where clause in mysql?

976

What is orm in mysql?

917

how you will Create a database on the mysql server with unix shell.

1058

What is database url for mysql?

965

Is mongodb faster than mysql?

959

What is truncate in mysql?

966

What is difference between pdo and mysqli?

1002

Does uninstalling mysql delete database?

1033

Why we use mysqli instead of mysql?

1102

How does triggers work in mysql?

986

Is mysql still relevant?

914

How do I find mysql version in mysql workbench?

949

How do I switch users in mysql?

977

List data types in mysql? Explain

930

What is database engine in mysql?

949