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
- 14569 Views
- I also Faced
- E-Mail Answers
Answer Posted / pious deepak
select salary from employee
order by salary desc limit n-1, 1
| Is This Answer Correct ? | 29 Yes | 4 No |
Post New Answer View All Answers
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
Why should I use mysql?
What are the security alerts while using mysql?
What is the role of a limit in a mysql query?
What is pdo in php mysql?
What is mysql database server?
Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?
How to filter data from a mysql database table with php?
What are the two types of queries?
How do I update a variable in mysql?
Is sql similar to mysql?
What are mysql data types?
What is the latest version of mysql?
How do I install and use mysql?
How to store binary data in mysql?
