how we can find nth max salary from an employe table by
using my sql?
Answer Posted / jithu
Another way is::
SELECT sal FROM sal a WHERE n = ( SELECT count(*) FROM sal
b WHERE b.sal < a.sal)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to calculate the difference between two dates?
Tell us something about heap tables?
What is datadir?
Can I use mariadb instead of mysql?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What is the limit of mysql database?
How to find second highest salary from a table?
Can mysql function return a table?
What is the maximum no of columns a table can have?
What does "i_am_a_dummy flag" do in mysql?
How to store binary data in mysql?
How to create a trigger in mysql?
What is pdo :: fetch_assoc?
Write a query to count the number of rows of a table in mysql.
What is slow query log in mysql?