select max(salary) from employee order by salary desc limit 1;

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

Question Posted / nivedita

Answer Posted / nivedita

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

2238

What are the differences between mysql vs sql server?

1063

How can you take the backup and restore a mysql database using php?

962

How do I copy an entire mysql database?

904

What is the use of count function in mysql?

1031

How to use rank function in mysql?

993

What is the difference between mysql and oracle?

969

What is mysql used for?

965

How to check if value already exists in mysql database in php?

890

How do stored procedures work?

1056

How would you get the current date in mysql?

1104

What is view? How can you create and drop view in mysql?

934

Is mysql an oracle product?

847

How do I show columns in mysql?

936

What data structure does mysql use?

1022