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
What are the similarities between a function and a procedure?
What is the usage of "i-am-a-dummy" flag in mysql?
What is a result set object?
What is 'mysqladmin' in mysql?
What is data types in mysql?
What is relational database in mysql?
How do I show columns in mysql?
How do you rename a table?
How to enter boolean values in sql statements?
What are the advantages of MySQL when compared with Oracle?
write a query to mysql in safe mode and to change the root password
How do I create a mysql database?
Give string types available for column?
What is regexp?
What is the use of innodb in mysql?