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
Can you assign multiple query result rows to a variable?
What do you mean by a tablespace?
How remove data files before opening a database?
IS it possible to built the oracle database without setting the kernal parameters?
What is an oracle wallet?
What is Reduced List of Values?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to add a new column to an existing table in oracle?
What is difference between cartesian join and cross join?
How to delete a user account in oracle?
Why is oracle used?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What to do if dba lost the system password?
What privilege is needed for a user to create indexes in oracle?
What are a collation and state the different types of collation sensitivity?