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

Answer Posted / nivedita

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

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is mysqli faster than mysql?

483


What is dump in mysql?

476


Why myisam is faster than innodb?

484


What command is used to delete the data from the table without deleting the table structure?

455


How to insert dynamic values in mysql using php?

537






What is the limitation of mysql?

475


What are the types of index?

512


HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

1813


Can I install mysql on mac?

522


Is there a way to see the files which are stored?

490


What are all the Common SQL Function?

569


What is the use of innodb in mysql?

476


How to use regular expression in pattern match conditions?

519


How do you name a table?

491


What are the advantages/disadvantages of mysql and php?

502