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
Why mongodb is faster than mysql?
What is a tinyint?
What are views in mysql?
What is unsigned in mysql?
Where does mysql store data?
What is difference mysql and mysqli?
How do I insert multiple rows in a table?
How large can a mysql table be?
How do I copy a table in mysql?
What is the usage of ENUMs in MySQL?
How can we get the number of rows affected by query?
How can you retrieve a particular number of records from a table?
How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.
Which is better sqlite or mysql?
How can we optimize stored procedure?