Interested to Buy Any Domain ? << Click Here >> for more details...
how we can find nth max salary from an employe table by
using my sql?
- 8 Answers
- 14564 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
What is the usage of "i-am-a-dummy" flag in mysql?
What is foreign key in mysql?
How do you shutdown a mysql database?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
How to check if value already exists in mysql database in php?
What is the default port for mysql and how it can change?
What are the differences between innodb and myisam engines?
how can you test for null values in a database? : Mysql dba
How we can get the current date in mysql?
Can we store pdf files in mysql?
How to create a new table in mysql?
What is mysql gpl?
How many mysql connections can handle?
Is sqlite faster than mysql?
I want to start and stop mysql on windows? How do I do that?
