1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / sreenu

Answers were Sorted based on User's Feedback



Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptn..

Answer / 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

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptn..

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

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptn..

Answer / 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

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptn..

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

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptn..

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

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptn..

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

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptn..

Answer / rakesh

select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

what is data modelling? what are types of modelling?In which suituation will use each one?

1 Answers   Accenture,

How informatica process data means how informatica works?

2 Answers   TCS,

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

2 Answers   DELL,

How many joins in Informatica

5 Answers   CSC,

How will u find weather dimension table is big in size of a fact table?

1 Answers  

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

What the difference is between a database, a data warehouse and a data mart?

1 Answers  

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

Explain reference cursor?

1 Answers  

what are presession,postsession success and postsession failure commands ?

1 Answers  

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers  

For more Informatica Interview Questions Click Here
Categories