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

Explain integrity constraints?

0 Answers  

What are a query and state the different types of queries and their uses?

0 Answers  

In the oracle version 9.3.0.5.0, what does each number shows?

0 Answers  

how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?

1 Answers  

Explain an exception and its types?

0 Answers  

How to use null as conditions in oracle?

0 Answers  

What is a Redo Log ?

3 Answers  

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

0 Answers   Mastek,

Query to get max and second max in oracle in one query ?

34 Answers   CTS, Keane India Ltd, TCS, Wipro,

what are the disadvantages of hierarchial database over RDBMS?

1 Answers   TCS,

What are the common oracle dba tasks?

0 Answers  

What is Data Dictionary Cache in Oracle?

0 Answers   MCN Solutions,