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
What is myisam?
Why should I learn mysql?
How to calculate expressions with sql statements?
Is mysql same as mariadb?
Is mysqli faster than mysql?
What are the difference between and myisam and innodb?
what is a cursor? : Mysql dba
Where is the myisam table stored?
What is procedures in mysql?
What is the password of mysql?
What is mysql workbench used for?
How Switch (select or use) to a database.
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
What is a mysql model?
How to add a new column to an existing table in mysql?