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
- 11219 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravikishore
select deptno,sum(sal) from emp group by deptno having
sum(Sal) =(select max(sum(sal)) from emp group by deptno)
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
Answer / aashish
select department_ID, sum(salary) from emp group by department_ID having sum(salary) > (select avg(sum(salary)) from emp group by department_ID);
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Why filter transformation is an active one?
What are the new features of informatica 9.x at the developer level?
How you count the number of records available at your source?
can anyone explain me about sales project in informatica?
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
Explain the informatica workflow?
The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?
What are the components of Informatica? And what is the purpose of each?
Can we get 1st record through Informatica(without sequence number).
What is the difference between STOP and ABORT options in Workflow Monitor?
define galaxy repository in informatica
Teradata 
