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

Difference between varchar and varchar2 data types?

1189

What is oracle instant client?

1028

Difference between pre-select and pre-query

1115

How to set up autotrace for a user account?

1061

How is it different from a normal table?

1038

How to create an initialization parameter file?

1059

Which is better Oracle or MS SQL? Why?

6395

what is reindexing?

1682

What do database buffers contain?

1040

Oracle

2380

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

1020

What are the differences between lov and list item?

1073

what is a Nested Loop join?

2119

What are the various types of snapshots ?

1032

Explain the difference between sap and oracle?

1036