Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
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 |
Post New Answer View All Answers
What are the four Oracle system processes that must always be up and running for the database to be useable?
How do I spool to a csv formatted file using sqlplus?
What is the dynamic sql in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Is oracle the best database?
Why do we need oracle client?
What is oracle in java?
What is Reduced List of Values?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How many types of synonyms in Oracle?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is system global area (sga) in oracle?
How can we delete duplicate rows in a table?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Explain do view contain data?