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

Is mysql a backend?

972

What is sqlyog?

1083

Write a program using the select statement, while loop.

966

Is mysql frontend or backend?

948

What is required to create mysql database?

1038

What is latest version of mysql?

1081

What is append query?

966

Is mysql query case sensitive?

1018

What do we use to remove duplicate records while fetching a data in mysql ?

1024

How do I assign a variable in mysql?

1065

What is mysql community edition?

1003

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1509

What does mysqli_fetch_assoc do?

968

What is heap table?

1078

Why myisam is faster than innodb?

995