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
- 20965 Views
- HCL, I also Faced
- E-Mail Answers
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
is cognos 7 is better than cognos 8
please please give me some banking calculations in framework manager.
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What are the different types of important services used in cognos? hi, i am searching job in cognos and datastage, does any
can provide me the real time experieced scenerios and
questions related to cognos and datastage projects, so if
anyone provide me the documents related this can very
helpful to me, my mail id is tchiru01@yahoo.com how can I test reports in cagnos? Write various indexes used in cognos? What is a Pivot? Can you define a catalog and types of catalogs in cognos? What are initial page components of Cognos connection? What DB View and Bus View? What is the use of Cognos scenario? What do you understand by the term 'aggregate cache'? what are slowly changing dimensions? Why we are used scd? If we are migrating lower version of Cognos reports (e.g.
from Ver 7.0 to Cognos 8) then how we migrate Impromptu
Catalog (ver 7.0) in Cognos 8? Do we create FM model for
that? Please explain.
