Interested to Buy Any Domain ? << Click Here >> for more details...
Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
- 6 Answers
- 17010 Views
- I also Faced
- E-Mail Answers
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
What is a trace file and how is it created in oracle?
How to apply filtering criteria at group level in oracle?
What is instant client oracle?
Explain a segment?
How to start your 10g xe server from command line?
Explain alias?
What is the difference between view and materialized view in Oracle?
List the parts of a database trigger.
Is there a combination of "like" and "in" in sql?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is procedure overloading in oracle?
What do you know about normalization? Explain in detail?
Explain about your project and its relation to the current job position you are applying to?
What are transaction isolation levels supported by oracle?
How to convert characters to dates in oracle?
