how we can find nth max salary from an employe table by
using my sql?
- 8 Answers
- 11288 Views
- I also Faced
- E-Mail Answers
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
Please Help Members By Posting Answers For Below Questions
How can you validate emails using a single query?
What is difference mysql and mysqli?
What is the difference between truncate and delete?
What is a table schema?
What is mysql optimization?
How to create table show example
What mysql -u john -p command does?
What is truncate command?
How does limit work in mysql?
What is the date format in mysql?
Why phpmyadmin is used for mysql?
What, if a table has one column defined as TIMESTAMP?
How do I start mysql?
Can we write pl sql mysql?
What is mysql aggregate functions? Explain
