select distinct(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 / ksam

Answer Posted / ksam

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

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is myisam?

930

Why should I learn mysql?

886

How to calculate expressions with sql statements?

1053

Is mysql same as mariadb?

869

Is mysqli faster than mysql?

883

What are the difference between and myisam and innodb?

980

what is a cursor? : Mysql dba

961

Where is the myisam table stored?

922

What is procedures in mysql?

901

What is the password of mysql?

930

What is mysql workbench used for?

943

How Switch (select or use) to a database.

1036

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

892

What is a mysql model?

905

How to add a new column to an existing table in mysql?

958