select deptno, max(sal) from emp group by deptno having max(sal)> (sele

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 / moorthy g

7 Answers
11017 Views
iGate, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sorter transformation?

1042

What are mapplets?

1265

What is the benefit of session partitioning?

1112

Where is metadata stored?

1108

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1056

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1951

Which transformation should we use to normalise the COBOL and relational sources?

1202

What is informatica worklet?

1062

How to generate sequence numbers using expression transformation?

1086

What is dynamic cache?

1030

What is a predefined event?

1089

What is the status code in stored procedure transformation?

1181

What is an aggregator transformation?

1096

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1081

hi real timers . iam waiting for ur reply regarding ETL TESTING

2268