select ename,sal,mgr from emp a where sal

Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)

Question Posted / pradeep

Answer Posted / pradeep

select ename,sal,mgr
from emp a
where sal > (select avg(sal)
from emp b
where b.mgr = a.mgr)

Is This Answer Correct ?

10 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is a dead lock in oracle?

1095

What do you mean by a tablespace?

1021

Give the constructs of a package, function or a procedure.

1015

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1053

What is recovery manager(rman) backup in Oracle?

1171

What are the oracle differences between nvl and coalesce

1125

Differentiate between pre-select and pre-query?

1079

How to delete a user account in oracle?

950

how may join possible between (requisition with purchase order)

2227

What is Undo Management Advisor in Oracle?

1077

Which is faster join or subquery in oracle?

970

What is pragma autonomous transaction in oracle?

1039

What are the differences between lov and list item?

1042

What is index-organized table in Oracle?

1052

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2252