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 happens if you no create privilege in a database?
Is mysql a framework?
What are the types of index?
Is mysql a good database?
What is full text indexing in mysql?
How we can create index in mysql?
How does mysql encrypt passwords?
How can you make a database as your current database?
What is foreign key in mysql?
Why use mysql procedures?
What is append query?
How can I see connections in mysql?
What is mysqli_select_db?
How do I rename a table in mysql workbench?
What is the difference between unix timestamps and mysql timestamps?