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 can I connect mysql database?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
What is the date format in mysql?
What is mysql common?
What is the latest version of mysql?
What is the difference between myisam dynamic and myisam static in mysql?
How to enter microseconds in sql statements?
In which language mysql has been written?
Where the database is stored in mysql?
SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?
How to represent ENUMs and SETs internally?
What is the return type of mysqli_query?
What is the command line end user interface - mysql?
Can we store files in mysql?
Can you tell the difference between ereg_replace() and eregi_replace()?