Interested to Buy Any Domain ? << Click Here >> for more details...
Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 21421 Views
- HCL, I also Faced
- E-Mail Answers
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
Can you define bitmap index?
Explain the different types of views used in cognos.
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What is cognos connection?
What are the steps to import the two data sources in framework manager?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
---------------Tell me about DWH Concepts?
-------------How you design DWH?
What are the services provided in cognos 8?
what is degenerate key in oracle ?whare do we use it?
Diff b/w Crossproduct and Outerjoin?
What are all the advantages of Cognos?
What do you understand by ‘ibm predictive maintenance and quality’?
How can create users and permissions in cognos?
Can you explain a cognos controller?
