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 analyze command used for?

1080

Whats the benefit of dbms_stats over analyze?

2008

What is BBED in Oracle?

1165

What is a user account in oracle?

1130

What is blob datatype?

1134

What is a nested table and how is it different from a normal table?

1061

What is oracle database client?

1038

Why does Oracle not permit the use of PCTUSED with indexes?

2428

Give syntax for SQL and ORACLE joins.

1099

How to define a variable of a specific record type?

1084

How to connect to a local oracle 10g xe server?

996

How do I recompile a procedure in oracle?

971

Explain the use of owner option in exp command.

1052

What is Virtual Private Database in Oracle?

1096

Why use resource manager in Oracle?

1111