how we can find nth max salary from an employe table by
using my sql?
- 8 Answers
- 11298 Views
- I also Faced
- E-Mail Answers
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
Is mysql a scripting language?
How we get sum of column.
What is InnoDB?
If we use sum function in mysql, does it return sum of that row or for that column?
How do I create a new database in mysql?
What is prepared statement in mysql?
What is the difference between having and where clause in mysql? Explain
What is mysql used for?
What is a scalar function?
Can we store images in mysql database?
What are the advantages of a procedure?
How to calculate the difference between two time values?
What is difference between pdo and mysqli?
How to create a table?
How is data stored in mysql?
