select ename,sal,mgr from emp mgr where sal

Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)

Question Posted / chakradhar

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Explain about achiever in sql?

981

does the query needs a hint to access a materialized view?

1817

How to select some rows from a table in oracle?

1008

Give syntax for SQL and ORACLE joins.

1042

How many types of segments in Oracle?

1014

Use of an integrity constraint is better to validate data. Explain

979

What is oracle analytical function?

1032

What is the fastest query method to fetch data from the table?

1296

How to delete all rows a table in oracle?

1010

Explain oracle instance.

1108

How to drop a stored function?

1085

what are archived logs?

2144

What is coalesce function?

1010

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2209

Can we call procedure inside function in oracle?

1021