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

What is the sql query to concatenate column values from multiple rows in oracle?

1106

How to open a cursor variable?

1091

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2398

How to use "for" statements in oracle?

1124

How to write a query with an inner join in oracle?

1096

State some uses of redo log files?

1067

Can we store pictures in the database and if so, how it can be done?

1089

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4571

What is the use of oracle?

1078

Explain what are clusters?

1158

What are the uses of linked server and explain it in detail?

1117

How can you use check constraints for self referential integrity?

1018

Why does Oracle not permit the use of PCTUSED with indexes?

2479

How to lock and unlock a user account in oracle?

1162

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

3023