select ename,empno from emp a where sal>(select avg(sal) from emp b wher

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

Question Posted / saiprasanna

Answer Posted / saiprasanna

select ename,empno from emp a where sal>(select avg(sal) from emp b where mgr=a.empno);

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2357

How to use subqueries in the from clause in oracle?

1165

How to define an anonymous block?

1247

Can we call procedure inside function in oracle?

1151

Explain the use of compress option in exp command.

1073

Can group functions be used in the order by clause in oracle?

1047

What is a data dictionary and how can it be created?

1240

What are the differences between lov and list item?

1147

What language does oracle use?

1169

What are the types of trigger in oracle?

1029

How to do a full database export?

1153

How to increment dates by 1 in oracle?

1138

What is private procedure oracle?

1050

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2234

How is it different from a normal table?

1084