Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
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 |
Post New Answer View All Answers
What is a dead lock in oracle?
What do you mean by a tablespace?
Give the constructs of a package, function or a procedure.
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What is recovery manager(rman) backup in Oracle?
What are the oracle differences between nvl and coalesce
Differentiate between pre-select and pre-query?
How to delete a user account in oracle?
how may join possible between (requisition with purchase order)
What is Undo Management Advisor in Oracle?
Which is faster join or subquery in oracle?
What is pragma autonomous transaction in oracle?
What are the differences between lov and list item?
What is index-organized table in Oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?