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
- 17366 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
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is meant by recursive hints in oracle?
What are the ways tablespaces can be managed and how do they differ?
How a tablespace is related to data files?
How to use "for" statements in oracle?
Whats the benefit of dbms_stats over analyze?
How many categories of data types?
Differentiate between post-database commit and post-form commit?
What is null value in oracle?
How would you change old and new values in an insert, delete and update triggers?
What are the various constraints used in oracle?
How to retrieve values from data fields in record variables?
Is there a combination of "like" and "in" in sql?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
what is normalisation?what are its uses?
