write a query to display to 10 max record from the employee
table?
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
Explain informatica architecture?
what is the main advantage of impromptu over cognos reportnet?
What is the difference b/w macros and prompt?
What are the batches and it’s details?
Is it possible to join multiple Databases in a Catalog?
what is requery in cognos?
-------------What is Coditional Prompting?
What is the use of cognos decision stream?
What do you mean by Drill down and Drill Up?
How is cognos model organization works?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
please please give me some banking calculations in framework manager.
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?
How to generate cubes in cognos?
What do you understand by the term 'aggregate advisor?'