Answer / chakradhar

select ename,sal,mgr
from emp mgr
where sal > (select avg(sal)
from emp emp
where emp.mgr = mgr.empno)

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

Answer / pradeep

select ename,sal,mgr
from emp a
where sal > (select avg(sal)
from emp b
where b.mgr = a.mgr)

Answer / saiprasanna

select ename,empno from emp a where sal>(select avg(sal) from emp b where mgr=a.empno);

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))

Answer / murali

select m.ename from emp e,emp m where e.mgr=m.empno and
e.sal<m.sal

How to connect ms access to oracle servers?

0 Answers  

What are the types of synonyms?

1 Answers  

What is Water Mark in Oracle?

7 Answers   Oracle,

What is Java Pool in Oracle?

0 Answers   MCN Solutions,

How to define and use table alias names in oracle?

0 Answers  

What to do if the binary spfile is wrong for the default instance?

0 Answers  

What is an oracle and why it is used?

0 Answers  

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

0 Answers  

Define 'view' advantage ?

2 Answers   AZTEC, TCS,

How can we force the database to use the user specified rollback segment?

0 Answers  

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

4 Answers   Infosys,

What is oracle server autotrace in oracle?

0 Answers