Write a query to display Which deptno is containing highest
Sal > avg (sum (Sal)) of all deptno;
Avg (sum (Sal)) o f all deptno= 9675
Deptno, sum (Sal)
10 8750
20 10875
30 9400
- 7 Answers
- 8955 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / rakesh
select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp group by deptno);
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is primary and backup node?
Write the unconnected lookup syntax?
What is the difference between router and filter?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is meant by target load plan?
What do you mean by enterprise data warehousing?
What is the difference between Active and Passive transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are multi-group transformations?
What are the different types of olap? Give an example?
What is the meaning of up gradation of repository?
What are Dimensional table?
Explain sql transformation in script mode examples in informatica
What is the reusable transformation?
What is the need of etl tools?
