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
How do I escape data before storing it in the database?
What is a php tag?
Define about declare construct?
What is basename php?
What is null value in php?
What are php strings?
Where are the persistent cookies stored on your computer?
How can we determine whether a variable is set?
Which php framework is fastest?
How can you get web browser’s details using PHP?
Is not null mysql?
What is the functionality of the functions strstr() and stristr()?
Explain php split() function.
Explain how can we increase the execution time of a php script?
What is the difference between array_merge() and array_merge_recursive() in php?
