Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
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
what is port in oracle? how is it related to database application.
What is the maximum limit on the number of columns in a table?
Is it possible to insert comments into sql statements return in the data model editor ?
how do u setup a replication site?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Difference between open_form and call_form in oracle.
Explain the use of analyse option in exp command.
What happens to the indexes if a table is recovered?
Explain the use of control file?
How to create a table index?
Explain what are the different type of segments?
How will you write a query to get a 5th rank student from a table student_report?
How to calculate date and time differences in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?