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 do you say mysql?

490


How many columns is too many mysql?

475


Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

532


How do I drop a database in mysql?

564


How to control the max size of a heap table?

553






Where is mysql data stored linux?

474


What does tinyint mean?

517


What is regexp?

660


How do I create a stored procedure in mysql?

497


Is microsoft sql same as mysql?

512


What is mysql url?

478


What are the drivers in MySQL?

746


How to change the database engine in mysql?

455


How many columns can you create for an index?

492


What is bigint in mysql?

518