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

How to convert times to characters in oracle?

979

What is data type in oracle?

1043

Why use resource manager in Oracle?

1052

How do you find current date and time in oracle?

990

What is a private synonym?

1531

What is a table in oracle?

928

What is the maximum number of triggers that can be applied to a single table?

956

How to connect to oracle using service name instead of sid?

964

Does oracle partitioning improve performance?

947

What is backup in Oracle?

952

How to load data from external tables to regular tables?

990

What is the difference between a hot backup and a cold backup in oracle?

961

How to define an external table with a text file?

1021

How to loop through data rows in the implicit cursor?

1016

What is clustered table in Oracle?

1108