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
- 17021 Views
- I also Faced
- E-Mail Answers
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
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
What are the roles of dba?
How to fetch the row which has the max value for a column?
How to run queries on external tables?
what is difference between sql plus and sql*plus? (not sql and sql plus).
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Explain oracle insert into command?
What are triggers in oracle?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What is recovery manager in Oracle?
How to drop an index in oracle?
interview questions with answer for cts
What is a server parameter file in oracle?
