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
- 14123 Views
- I also Faced
- E-Mail Answers
Answer Posted / ksam
select distinct(salary) from employee order by salary desc
limit n-1,1
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How many ways we can retrieve the date in result set of mysql using php?
How to store binary data in mysql?
How to update database permissions/privilages.
How do you use auto increment?
What is InnoDB?
Why do we use mysql?
How to show table structure mysql?
Where does mysql store data?
why not null is not allowed at table level
What command is used to delete the data from the table without deleting the table structure?
How will you export tables as an xml file in mysql?
Which datatype is used for email in mysql?
What is the current mysql version?
What are the advantages/disadvantages of mysql and php?
How do I run a query in mysql?
