how we can find nth max salary from an employe table by
using my sql?
Answer Posted / sandeep
select MAXIMUM(salary) from (select salary from employee
order by salary desc limit 'n')
n means number of rows
| Is This Answer Correct ? | 10 Yes | 18 No |
Post New Answer View All Answers
What is row?
Why to use char instead of varchar in the database?
Give string types available for column?
Can we store files in mysql?
What is mysql and mysqli?
What is clob in mysql
How will show all records containing the name "sonia" and the phone number '9876543210'
Why we use mysqli instead of mysql?
What is row level locking in access?
What are the other commands to know the structure of a table using mysql commands except explain command?
How can you make a database as your current database?
How to store values to array from mysql database in php?
Why is mysql popular?
What is the difference between char and varchar?
What are the security alerts while using mysql?