select ename,sal,mgr from emp a where sal

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

Question Posted / pradeep

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

Please Help Members By Posting Answers For Below Questions

Explain the use of tables option in exp command.

1117

Explain how you would restore a database using RMAN to Point in Time?

2146

How to define an oracle cursor variable?

1032

How to select all columns of all rows from a table in oracle?

1055

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1109

Difference between varchar and varchar2 data types?

1189

How many types of table in Oracle?

1128

How to delete a column in an existing table in oracle?

1073

What is a sub query? What are its various types?

1179

What are the different oracle database objects?

1094

How to create an oracle database manually?

1089

What is bulk collect in oracle?

999

How to do clean up if create database failed?

1030

what is the difference between data migration and production migration.

2347

How can I see all tables in oracle?

1011