Interested to Buy Any Domain ? << Click Here >> for more details...
Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
- 6 Answers
- 17146 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 to Select second Maximum salary in a Table ?
What is backup in Oracle?
What is system tablespace?
What is a cursor and what are the steps need to be taken?
Calculate difference between 2 date / times in oracle sql?
What are the different types of modules in oracle forms?
What is the difference between 10g OEM and 11g OEM?
What is connection pooling in oracle?
What is execute immediate in oracle?
How to shutdown your 10g xe server?
Is it possible to enter only time value into a column of a table in sql?
How to use like conditions in oracle?
Oracle General 
