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
- 16889 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 |
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Draw E-R diagram for many to many relationship ?
What is raw datatype in oracle?
What is memory advisor in Oracle?
IS it possible to built the oracle database without setting the kernal parameters?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What happens if you lost a data file?
how many columns can a plsql table have
What is the dynamic sql in oracle?
Select the Nth lowest value from a table?
Oracle General 
