write a query to display to 10 max record from the employee
table?
- 7 Answers
- 12523 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / srinu
select * from(select rownum r,emp.*from emp order by sal
desc) where r<=10;
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What is the metric store database?
What is a Transformer?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
Can you define bitmap index?
WHAT ARE THE DISTNICT VARIABLES?
What do you mean by drill across?
What is cognos powerhouse?
Mention the difference between ‘macros’ and ‘prompt’?
how u will determine the performence tune will occur either in report or system
What are the two types of framework manager?
What is the difference between the content store and content manager?
-------------How you design DWH?
What is the difference between group and associare?
-----------Diff b/w OLAP and RDBMS?
