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
- 17157 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 create a new database in oracle?
How to rollback the current transaction in oracle?
Is the After report trigger fired if the report execution fails ?
How to remove a row in a database table?
Can objects of the same schema reside in different tablespace?
How to call a stored function with parameters?
What are the attributes of cursor?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
What is tns service name?
How do we switch from init.ora file to asp file?
How to change user password in oracle?
what is the difference between functional dependecy and multilevel dependency?
Oracle General 
