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

What are internal user account in oracle?

1011

Explain what does a control file contain?

1103

How do I call oracle stored procedures that take no parameters?

1120

What is a select query statement in oracle?

970

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2288

How to select some columns from a table in oracle?

1097

Explain constraining triggers.

1101

How many types of segments in Oracle?

1070

How to retrieve data from an explicit cursor?

1062

Can a formula column be obtained through a select statement ?

2330

What is the minimum client footprint required to connect c# to an oracle database?

1096

How to convert times to characters in oracle?

1027

What are the limitations of check constraint?

1033

How to update values on multiple rows in oracle?

1035

What is instant client oracle?

1023