select * from emp a where sal>(select avg(sal) from emp b where a.deptn

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

7 Answers
10786 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

Please Help Members By Posting Answers For Below Questions

Explain how many types of dimensions are available in informatica?

1010

What are the mapping parameters and mapping variables?

1091

What is flashback table ? Advance thanks

1874

How do you use reject loader.

2547

Clarify the utilization of aggregator cache record?

946

Define enterprise data warehousing?

1131

What is option by which we can run all the sessions in a batch simultaneously?

1082

What are active transformations.

1597

Define Pmrep command?

999

What is lookup change?

989

How we can create indexes after completing the loan process?

1146

How do you load first and last records into target table?

1102

What is a pre-defined event and user-defined event?

976

Differentiate between router and filter transformation?

954

What is the difference between Active and Passive transformation?

1085