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

What is sqlyog?

1002

What is difference between inner vs self vs cross?

930

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

868

Can mysql scale horizontally?

954

How can I see all mysql databases?

858

Is sql similar to mysql?

844

What is blob in mysql?

984

Give string types available for column?

960

How to insert dynamic values in mysql using php?

1097

What is mysql connector used for?

900

What is strict mode in mysql?

863

Is there a free mysql?

854

What are the differences between mysql vs sql server?

988

How are mysql timestamps seen to a user?

974

What are the 5 r's of managing behaviors?

1042