Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17537 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / dhanu
SELECT DISTINCT SAL FROM EMP E WHERE 5>=(SELECT COUNT(DISTINCT SAL) FROM EMP A WHERE A.SAL<=E.SAL)ORDER BY SAL DESC
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a cascading report and drill through report?
Can you define cognos impromptu?
What do you understand by ‘ibm predictive maintenance and quality’?
Why are meta service important then other services?
Can you define cognos powerplay?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
what is stitch query in reportnet?
Define the slice and dice?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
What are the ways to import data into catalog?
What are the components of report net?
how to connect datamarts
-------------What is Coditional Prompting?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What do you understand by the cognos?
