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
How do I backup mysql database on linux?
Can we join 3 tables in mysql?
What is view in mysql?
How can you count the total number of records of any table?
How to get nth highest salary from table in a mysql?
Is mariadb better than mysql?
How do I install mysql workbench?
How do I connect to a database in mysql workbench?
what are the different tables present in mysql? : Mysql dba
How we can get the current date in mysql?
Is mysql a backend?
How can you handle the –secure-file-priv in mysql?
How do you use auto increment?
What are the differences between binary and varbinary?
Does uninstalling mysql delete database?