how to create average on totals of different departments
employees salary...? consider we have 3 dept and in each
dept 10-15 workers i need to get the totals separately for
each dept and average of there totals..help me pls
Answer Posted / lakshmi reddy
select avg(depttotal) from (select sum(sal) as depttotal
from emp group by deptno)
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is Bitmap Index?
Can you define cognos impromptu?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
how to create measures and dimensions?
what are the features in cognos8ui
What are the different types of important services used in cognos?
What are all the types of gateway used in Cognos?
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
What is a Transformer?
what is log in cognos?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
How do we drill through from a powerplay cube to reportnet?\
1. Explain your project.
Can we test the report other than manual testing?