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 is the purpose of mysql database?
What is a heap table?
How is data stored in mysql?
What are the differences between char and varchar?
How do I declare a variable in mysql?
Write command to import an mysql file?
What is a deterministic function?
In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...
What are the types of queries?
How do I disable mysql?
How do I restore a database in mysql workbench?
How do I delete a mysql user?
What is a join in mysql?
What is meant by sharding?
how to connect a php script with the mysql database?