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
- 8926 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / moorthy g
select deptno, max(sal) from emp group by deptno
having max(sal)> (select avg(max(sal)) from emp group by
deptno);
Output:
DEPTNO MAX(SAL)
---------- ----------
10 5000
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Enlist the advantages of informatica.
What is DR strategy for Informatica project?
What is the format of informatica objects in a repository?
How can we create index after completion of load process?
Under which circumstances, informatica server creates reject files?
Is it possible to define a single node as a Gateway node as well as worker node?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
how to create user defined function (udf) in informatica
What does reusable transformation mean?
How many transformations can be used in mapplets.
On which transformations you created partitions in your project?
What is meant by incremental aggregation?
What is the sequence generator transformation in informatica?
How can we store previous session logs?
Where do we use mapping variables in informatica?
