write a query to display to 10 max record from the employee
table?
- 8 Answers
- 10631 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / madhusudhan
select rownum rn,(select e.* from emp e)
order by sal desc
where rn>=&rn;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is difference between content store and content manager?
Can you define cognos powerplay?
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?
What is called a slice?
Explain the difference between powerplay transformer and power play reports?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
what is power prompt in cognos ep7series?what is the use of this?
What is defined as data mining?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Why is auto-regression used in forecasting used on cognos platform?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
can we insert all types of charts in a list report? what r the realtime prompts?
What do you mean by Drill down and Drill Up?
