how we can find nth max salary from an employe table by
using my sql?
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
Can a table have multiple primary keys?
What is the default password for mysql?
What are the functions of mysql?
What is definer in mysql trigger?
What is session variable in mysql?
How to find the unique values if the value in the column is repeated?
How do I remove a user from mysql?
What is mysql data directory?
Why use mysql procedures?
explain GROUPBY & HAVING clause with examples.
How to get data from mysql in php?
What is the insert?
How can we get the number of rows affected by query?
How do I change global variables in mysql?
What is InnoDB?