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
write a query to mysql in safe mode and to change the root password
What storage engines are used in MySQL?
What are the different types of triggers in mysql?
what is constraints? Also explain the different types of constraints?
What is the latest version of php and mysql?
How can you change the name of any existing table by using the sql statement?
Can varchar be primary key?
Can I copy mysql data directory?
How to get a list of columns in an existing table?
What are the steps involved in query processing?
What is schema in mysql?
What is different between sql and mysql?
Where is the mysql database stored?
Can we store files in mysql?
What is a crosstab query?