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
write a query to mysql in safe mode and to change the root password
How to enter numeric values as hex numbers?
How to show table names with 'mysqlshow'?
Does mysql use t sql?
Is mysql open source?
What is mysqli_select_db?
What port is mysql running on?
How do I stop a query in mysql workbench?
What is the use of i-am-a-dummy flag in mysql?
How to set the time zone for MySQL to particular country time?
How many ways we can retrieve the date in result set of mysql using php?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
Explain about the architecture of MYSQL?
How would you enter characters as hex numbers?
What tools available for managing mysql server?