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

Write a query to find duplicate rows in table?

854

what is the default port for mysql server? : Mysql dba

980

Is mysqli deprecated?

892

How to use like conditions?

919

What is mysqli procedural?

912

What is a text delimiter?

870

How to dump a table to a file with 'mysqldump'?

953

What is the difference between mysql and pdo?

893

What is the use of count function in mysql?

974

What is truncate command?

870

What is myisam?

907

What is mysqli_result?

880

What is database in php mysql?

929

How to analyze tables with 'mysqlcheck'?

1142

What are string data types?

974