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 are internal user account in oracle?
Explain what does a control file contain?
How do I call oracle stored procedures that take no parameters?
What is a select query statement in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to select some columns from a table in oracle?
Explain constraining triggers.
How many types of segments in Oracle?
How to retrieve data from an explicit cursor?
Can a formula column be obtained through a select statement ?
What is the minimum client footprint required to connect c# to an oracle database?
How to convert times to characters in oracle?
What are the limitations of check constraint?
How to update values on multiple rows in oracle?
What is instant client oracle?