Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10871 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
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is aggregator transformation in informatica?
Write the unconnected lookup syntax and how to return more than one column.
What is blocking transformation?
Explain dynamic target flat file name generation in informatica
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain what is informatica metadata and where is it stored?
Can we create two repositories on same database instance in oracle?
What is a grid in Informatica?
How to do the error handling of if ur source is flatfiles?
Enlist the differences between database and data warehouse.
What is data movement mode in Informatica and difference between them?
What is fact table? Explain the different kinds of facts.
What you know about transaction control transformation?
Write the different tools in the workflow manager?
