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
- 8962 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / jz
select deptno,max(sal) from emp
group by deptno
having max(sal)>(select avg(sum(sal) )from emp
group by deptno)
:)
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain the different dimensions.
Can we get 1st record through Informatica(without sequence number).
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What do think which one is the better joiner or look up?
my source is junk data how will u remove that junk data by using unix please any one replay me
What is update strategy transform?
what is mean by complex business rule ?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the different types of transformation available in informatica.
How to do the error handling of if ur source is flatfiles?
What is fact table? Explain the different kinds of facts.
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How does a sorter cache works?
What is difference between a gateway node and worker node?
