Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
- 6 Answers
- 14959 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 |
How many types of cluster table in Oracle?
What is oracle datasource?
Explain the use of online redo log files in oracle.
How to Identify the previously inserted/updated records in already populated table.
What are the uses of synonyms?
What is logical backup in oracle?
What are the Limitations of a CHECK Constraint ?
Explain an exception and its types?
query optmization techniques and quwry analyser+projects+ppts
What do database buffers contain?
What are the factors causing the reparsing of SQL statements in SGA?
Explain the dml?
Oracle General 
