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
How does mysql encrypt passwords?
What is clob datatype?
What does mysql flush hosts do?
How can you export the table as an xml file in mysql?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
What is the purpose of -> in the mysql terminal?
What is meant by decimal (5,2)?
Is mysql a good database?
What is data types in mysql?
What is mysql default database?
How to validate email addresses in mysql?
Is mysql a server?
What is deterministic in mysql?
How do I clear the command in mysql?
What is federated tables in mysql?