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
What is the use of mysql workbench?
How can we run batch mode in mysql?
What is datatype in mysql?
How do I completely remove mysql from windows?
What is pragma exception?
What is the use of mysql_fetch_array () function in php?
List some comparisons operators used in mysql?
How to define numeric 9(3) in db2 table without decimal point??
How can I remotely connect to mysql database?
Is mysql still relevant?
Where is mysql used?
How to decrement dates by 1 in mysql?
How do I start mysql client?
Does mysql use tcp or udp?
What is mysql data directory?