Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / karthik murugeshan
SELECT B.Salary FROM (SELECT Salary FROM EMP)A,(SELECT
Salary FROM EMP)B
WHERE A.Salary>=B.Salary
GROUP BY B.Salary
HAVING COUNT(B.Salary)=5
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How is cognos model organization works?
difference between impromptu and cognos8
What is the use of cognos decision stream?
What is the difference between a cascading report and drill through the report?
Please explain the different stages in creating a report in cognos report net?
Can you define pivot?
hi friends pls forward impropmtu interview question
What is the difference between Standard and Metrics folder?
Define metrics studio?
What you mean by drill across?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
what is the role of cognos comsultant?what actually it means?pls reply
What is the difference between group and associare?
What junk dimension contains?
What are the steps to import the two data sources in framework manager?