how we can find nth max salary from an employe table by
using my sql?
Answer Posted / whatinaname
select max(salary) from employee
order by salary desc limit n-1, 1
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What is difference between microsoft sql and mysql?
What is mysql workbench used for?
What are the security alerts while using mysql?
What is the use of mysql workbench?
How is mysql database stored?
How to update database permissions/privilages.
Do I need to pay for mysql?
What is mysql protocol?
Restore database (or database table) from backup.
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
How to set the time zone for MySQL to particular country time?
Give string types available for column?
How do we use % when performing a search query?
Is mysql server free?
How do I change directories in mysql?