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
- 20907 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
Write types of folders present in cognos?
Can you define cube?
How can create users and permissions in cognos?
What are the types of studio?
What do you understand by the term 'model durability'?
What are the types of studio present in Cognos?
Explain what is the difference between microstrategy and cognos reporting tool?
write a query to display the departments with no employee?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What are the components used in web tier?
how to merge 2 crosstabs thans
What do you understand by user class in cognos?
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?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
