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
- 20601 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / balanandam
select * from((select * from emp order by sal desc where rownum<=5)MINUS(select * from emp order by sal desc where rownum<=4))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What are the advantages of shortcuts?
What you mean by drill across and what is the difference between drill through, drill across?
what is model and say about process how to create model and how to test model?
What is the function of cognos dispatcher?
What is the difference between Open Connection command ang Open Session Command?
What is the difference between drill through, drill across?
Can you explain new content durability?
What are the types of studio present in Cognos?
-----------------What is Determination Model?
how you create security to reports?
What are all the types of gateway used in Cognos?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
Can you define transformer?
4. How many dimensions did you use in your reports?
