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 may join possible between (requisition with purchase order)

2170

Explain the use of indexes option in exp command.

1066

What is the difference between Delete, Truncate and Drop in Oracle?

1067

How to end the current transaction in oracle?

966

How to write numeric literals in oracle?

1128

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1670

How to create an oracle database?

978

How to define a sub function?

1084

Compare and contrast between sql and sql server and explain its various functions?

920

Explain mutating triggers.

974

What is the difference between I and G in Oracle?

1023

How to convert characters to numbers in oracle?

1001

What do you understand by a database object? Can you list a few of them?

971

How to invoke the data pump import utility?

1082

Why does for update in oracle 8 cause an ora-01002 error?

935