select 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 / pious deepak

Answer Posted / pious deepak

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

Is This Answer Correct ?

29 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is mysql url?

851

Is mysql case-sensitive?

873

What is mysql server used for?

935

What are the non-standard sql commands supported by 'mysql'?

969

How many tables we can create in mysql database?

934

What is difference between mysql_connect and mysql_pconnect?

1013

How to rename an existing column in a table?

1038

How do I find my mysql username and password?

950

How to drop an existing table in mysql?

999

How do you shutdown a mysql database?

1026

What are date and time data types in mysql?

1000

Explain % and _ inside like statement?

989

Why do we write stored procedures?

903

Is mysql relational?

896

How can you plan the logshipping before processing?

2312