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
- 8949 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / shankar
select * from emp a where sal>(select avg(sal) from emp b
where a.deptno=b.deptno)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In which transformation you cannot drag ports into it?
What is native users?
Is there any target staging area in informatica not staging area
What are the basic requirements to join two sources in a source qualifier transformation using default join?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is substr in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
What is the meaning of up gradation of repository?
How big was your fact table
Differentiate between Load Manager and DTM?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is pmcmd command?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Differentiate between router and filter transformation?
What is the command used to run a batch?
