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

Why use mysql procedures?

925

Does mysql need a server?

855

Is mysql server free?

869

How to create a table index in mysql?

893

How to validate email addresses in mysql?

1046

What are the column comparisons operators?

1171

How to load a csv file into a table

977

Where’s database data actually stored?

902

How do I automate a backup in mysql?

918

What is row level locking in access?

829

Write a query to display even rows in student table using mysql?

847

Can you tell what are various ways to create an index?

817

What is heap table in mysql?

910

How do I get a list of table names in mysql?

874

What is mysql_connect?

900