how we can find nth max salary from an employe table by
using my sql?
Answer Posted / sumit
select salary from employee e1
where (n-1)=(select count(*) from employee where
salary>e1.salary)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to update a root password.
How do you connect MySQL database with PHP?
How do I kill a mysql query?
Can you tell the difference between ereg_replace() and eregi_replace()?
How do I know if mysql is running on windows?
What ascii 31?
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 do I flush privileges in mysql?
What is longblob in mysql?
Can you tell the difference between $message and $$message?
How do I download a mysql community server?
How can we run batch mode in mysql?
What is mysql root?
What is localhost in mysql?
How can I remotely connect to mysql database?