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
- 21413 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
Write types of folders present in cognos?
how you create security to reports?
What are all types of Batches?
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.
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
Can you define drill down and drill up?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Can you define slice?
How is cognos model organization works?
can we insert all types of charts in a list report? what r the realtime prompts?
what is the difference between list report and crosstab report?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
What is meant by alternate drill down with ex?
What is the difference between group and associare?
