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 long does a php session last for?
Is php easier than javascript?
Explain me soundex() and metaphone()?
What is a lambda function in php?
Tell me what kind of things have you done on the social side?
What are the main error types in php?
Can a trait extend a class php?
Write a program to get second highest number in an array using php?
What is difference between web service and api?
Tell us how to set cookies in php?
What are properties in php?
Is php still used?
What is singleton design pattern in php?
Tell me what's the difference between include and require?
What is restful api?
