Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / sreenivasa
SELECT DEPTNO, ENAME, SAL FROM EMP A WHERE 4 = (SELECT COUNT
(B.SAL) FROM EMP B WHERE A.SAL < B.SAL)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
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 is the use of cognos decision stream?
Please explain the different stages in creating a report in cognos report net?
What is the difference between static and dynamic conditions?
Can you define set to be cardinality?
Why cognos decision stream is used?
What do you mean by Drill down and Drill Up?
How can I test reports in cagonos?
How can you link a query to a data container manually in Report Studio?
Can you define folder?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
what is log in cognos?