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

Answer Posted / pious deepak

select salary from employee
order by salary desc limit n-1, 1

Is This Answer Correct ?    29 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we find out which auto increment was assigned on Last insert?

622


Is mysql same as mariadb?

475


What is the command line end user interface - mysql?

525


What is difference mysql and mysqli?

507


How does mysql clustering work?

479






What is root password?

473


How To see all the tables from a database of mysql server.

577


What are the indexes in mysql?

501


Why myisam is faster than innodb?

483


How many triggers are possible in mysql?

507


Is mysql better than oracle?

471


What is the maximum size of table in mysql?

552


How will show all records containing the name "sonia" and the phone number '9876543210'

522


How can I change database in mysql?

452


Why is the basic difference between left join, right join and inner join?

548