Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17534 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
Can you define materialized view?
What do you understand by the term 'model durability'?
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 ?
How do we drill through from a powerplay cube to reportnet?\
what is log in cognos?
Define olap designer?
-----------------What is Determination Model?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
7. What is performance tuning?
What r the names of the reports that you prepared?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What is main difference mapplets and mapping?
What do you understand by the term 'aggregate cache'?
What is difference between page break and section report?
What are the advantages of using cognos sql?
