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 user in mysql?
What is difference between unix timestamp and mysql timestamp?
What are the differences between char and nchar?
How can you retrieve a particular number of records from a table?
What is difference mysql and mysqli?
What is sharding in mysql?
How you can create a trigger in mysql?
How do I start mysql client?
What is mysql data directory?
How to enable or disable a row of a table using MySQL in struts?
What is the data source name for mysql?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
Why do we use mysql?
Why is mysql used?
What is text in mysql?