select distinct m.ename from emp e,emp m where m.sal>(select avg(e.sal)

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

Question Posted / sehajshangari1235

Answer Posted / sehajshangari1235

select distinct m.ename from emp e,emp m
where m.sal>(select avg(e.sal) from emp e,emp m where
e.mgr=m.empno);

call back for more
7204719446

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is dynamic proxy?

963

What are a cluster and non-cluster index?

958

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1012

How to view all columns in an existing table?

876

What are the four Oracle system processes that must always be up and running for the database to be useable?

956

What is define in oracle?

1000

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

920

How to resolve the ORA-39133 error in Oracle?

1034

What are the system predefined user roles?

985

How to execute a stored procedure in oracle?

1031

How do I start tns listener?

989

Can we convert a date to char in oracle and if so, what would be the syntax?

960

What happens to the current transaction if the session is killed?

927

Explain what are clusters?

1042

What are dml statements in oracle?

1045