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

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

Question Posted / murali

Answer Posted / murali

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

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to get last row id?

970

Please explain oracle left join with an example?

1019

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1925

How to define a record variable to store a table row?

1041

What is Trigger in Oracle?

1135

How to install oracle odbc drivers?

1076

What is an oracle and why it is used?

1128

what happened to the global index when I truncate the data in one of the partition?

2009

How to add a new column to an existing table with a default value?

1001

How can I introduce multiple conditions in like operator?

970

What is the Tune Query

2268

How to filter out duplications in the returning rows using oracle?

1006

What is the difference between a user and a schema in oracle?

1018

Give the various rollback segment states.

1031

what is the scenario where you take the database to NoArchivelog mode?

2304