Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is member variable?
Explain about the $_GET variable of PHP?
How can we get the error when there is a problem to upload a file?
Differences between get, post and request methods ?
What does the expression exception::__tostring means?
What is the difference between php and java?
What is a http session?
Why echo is faster than print in php?
Is php open source?
What is composer install?
Explain the difference between isset() and empty()?
Is polymorphism inherited?
What is scope of variable in php?
What is the use of header in php?
Which programming language does php resemble?
