Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
- 6 Answers
- 14949 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chakradhar
select ename,sal,mgr
from emp mgr
where sal > (select avg(sal)
from emp emp
where emp.mgr = mgr.empno)
| Is This Answer Correct ? | 10 Yes | 2 No |
Answer / sehajshangari1235
select distinct m.ename from emp e,emp m
where m.sal>(select avg(e.sal) from emp e,emp m where
e.mgr=m.empno);
call back for more
7204719446
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
Answer / saiprasanna
select ename,empno from emp a where sal>(select avg(sal) from emp b where mgr=a.empno);
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / lal ajith kumara
select distinct (first_name)
from employees
where employee_id in (select manager_id
from employees
where salary > (select avg(salary) from
employees))
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / murali
select m.ename from emp e,emp m where e.mgr=m.empno and
e.sal<m.sal
| Is This Answer Correct ? | 0 Yes | 4 No |
What is recovery manager(rman) backup in Oracle?
What are triggers in oracle?
What is Data Block ?
Where are the settings stored for each instance in oracle?
How to grant create session privilege to a user in oracle?
How will you write a query to get a 5th rank student from a table student_report?
How do I manually create a database in oracle?
Who i will insert 1 lacks record in a Database table
Explain the use of ignore option in imp command.
What privilege is needed for a user to create views in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What happens if you set the sga too low in oracle?
Oracle General 
