Answer Posted / ankur gupta
FOR Nth Highest Salary Where N= 1,2,3,4
SELECT * FROM EMP E1 WHERE N=(SELECT COUNT(DISTINCT SAL)
FROM EMP E2 WHERE E1.SAL <= E2.SAL)
I have tested This Query on MySQL 5.1.41. its working fine.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do I update php?
What does the unset() function mean?
What are form input html tags?
How to read a file in binary mode?
What is the meaning of a persistent cookie?
How can we change the value of a constant?
Explain me the difference between include and require?
How to find the length of a string?
How can I make a script that can be bilingual (supports english, german)?
Why php is also called as scripting language?
Explain the ternary conditional operator in php?
What are the methods to submit form in php?
What is the use of mysql_real_escape_string in php?
Tell me how to create a text file in php?
What are the differences between GET and POST methods in form submitting?
