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
how may join possible between (requisition with purchase order)
Explain the use of indexes option in exp command.
What is the difference between Delete, Truncate and Drop in Oracle?
How to end the current transaction in oracle?
How to write numeric literals in oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
How to create an oracle database?
How to define a sub function?
Compare and contrast between sql and sql server and explain its various functions?
Explain mutating triggers.
What is the difference between I and G in Oracle?
How to convert characters to numbers in oracle?
What do you understand by a database object? Can you list a few of them?
How to invoke the data pump import utility?
Why does for update in oracle 8 cause an ora-01002 error?