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
- 8920 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
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
without table how to come first record only in oracle?
wat are deployement groups in informatica, how it will be used for developers
Design time, run time. If you don't create parameter what will happen
What are pre and post-session shell commands?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is powercenter on grid?
Explain sql transformation in script mode examples in informatica
What is a surrogate key?
What will be the approach?
What is data caches/ index caches?
Difference between Target-based loading and constraint-based loading?
my source is junk data how will u remove that junk data by using unix please any one replay me
How to differentiate between the active and passive transformations?
Write the program through which the records can be updated?
What is a filter transformation and why it is an active one?
