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

Where is the myisam table stored?

1012

How do I install and use mysql?

1002

what is the procedure to configure the application of mysql?

1104

How can I compare two mysql databases?

1025

How do I add a column to a table in mysql?

972

What is procedural api?

1049

What is the purpose of using a heap table?

1198

Explain the storage engines in mysql?

1060

What are the two types of queries?

1038

What is pragma serially_reusable and why is it used?

911

How to create a trigger in mysql?

986

Write a query to display current date and time?

980

How to get current MySQL version?

1151

How do I find mysql location?

1017

How do I rename a procedure?

925