Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
- 6 Answers
- 14991 Views
- I also Faced
- E-Mail Answers
Answer Posted / pradeep
select ename,sal,mgr
from emp a
where sal > (select avg(sal)
from emp b
where b.mgr = a.mgr)
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
How can I combine multiple rows into a comma-delimited list in oracle?
How many types of segments in Oracle?
How to check the server version in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
 How to use an oracle sequence generator in a mapping?
Explain the use of Merge statement in oracle 11g
Can we store pictures in the database and if so, how it can be done?
How to convert characters to times in oracle?
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 to rename an index?
What are the database administrators utilities available?
How to load excel data sheet to oracle database
What are the differences between interval year to month and interval day to second?
How data locks are respected in oracle?
What happens if recursive calls get out of control?
