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
- 17375 Views
- I also Faced
- E-Mail Answers
Answer Posted / murali
select m.ename from emp e,emp m where e.mgr=m.empno and
e.sal<m.sal
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Explain the use of log option in exp command.
What is the difference between sharding and replication?
What is translate in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the attributes that are found in a cursor?
What is data file?
What is meant by joins?
List out the components of logical database structure of oracle database.
How to drop a tablespace?
List the various oracle database objects?
Explain an exception and its types?
Explain the use of rows option in exp command.
What is the dynamic sql in oracle?
What is a package in oracle?
How to set up autotrace for a user account?
