how we can find nth max salary from an employe table by
using my sql?
Answer Posted / sandeep
select MAXIMUM(salary) from (select salary from employee
order by salary desc limit 'n')
n means number of rows
| Is This Answer Correct ? | 10 Yes | 18 No |
Post New Answer View All Answers
What is the function of mysqldump?
How do I find mysql database?
Is oracle mysql free?
Is mysql a dbms?
How do you concatenate strings in mysql?
How to create a trigger in mysql?
How to check if a record exists in a mysql database php?
What is the return type of mysqli_query?
using primary can we relate two table, with out foreign key?
What is procedure in mysql?
How do you know the version of your mysql server?
What are Heap tables?
What is the difference between char and varchar in mysql?
Where the database is stored in mysql?
How do I install the latest mysql on ubuntu?