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
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
What are products of cognos?
Define olap designer?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
Define cognos report net?
What is difference between primary key and unique key constraints?
What r the names of the reports that you prepared?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
Can you explain model durability?
what is stitch query in reportnet?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Tell me about Dnamic and Static Dashboards?
What are query items?