Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 16469 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / balanandam
select * from emp where sal =(select sal from(select sal,rank() over(order by sal desc) sal_rank from emp group by sal) where sal_rank=&rank)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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?
Can you define snapshot?
What is the difference between drill through, drill across?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
Can you explain cognos planning?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......
What do you mean by drill across?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
how to test reports in cognos?
What is cognos connection?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
what are the dimensions that you have in your current project?list them?
how u will design the report if the objects are available
