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
- 20422 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rakesh
select rownum as rank,name,sal
from
( select name,sal from employees order by sal desc)
where
rownum=5
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
what is degenerate key in oracle ?whare do we use it?
Can you define metrics designer?
-----------With out using DrillThrough how to do Reports?
5. Which type of report you build more, list, crosstab or chart and why?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
What are all the types of indexes in Cognos?
What is set to be cardinality?
Name the types of report?
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.
Can you explain cognos planning?
how you migrate reports to cognos 8 from previous versions?
is cognos 7 is better than cognos 8
How to publish a package by running Java Script?
What is the difference between drill through, drill across?
-------------What is Coditional Prompting?
