Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
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 |
Post New Answer View All Answers
How to view the tablespaces in the current database?
How to name query output columns in oracle?
Where do we use decode and case statements?
Difference between cartesian join and cross join?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is truncate oracle?
Can we commit inside a function in oracle?
How to update values on multiple rows in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to create a new view in oracle?
How to get last row id?
What is the usage of analyze command in oracle?
How to filter out duplications in the returning rows using oracle?
How to insert multiple rows with one insert statement in oracle?
How to call a stored function in oracle?