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
- 2 Answers
- 5358 Views
- Patni, I also Faced
- E-Mail Answers
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
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
Why cognos decision stream is used?
What is called cognos reporting tool?
Can we test the report other than manual testing?
Can you explain dynamic query mode?
What is the size of database for you project?
Can you define a datastore in cognos?
what is online view?
What is defined as data mining?
What is metric store database?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is drill down and slicing and dicing whats the difference between them?
What you mean by drill across?
what is the difference between native sql and cognos sql?
What is a Cube?
