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
- 17130 Views
- I also Faced
- E-Mail Answers
Answer Posted / lal ajith kumara
select distinct (first_name)
from employees
where employee_id in (select manager_id
from employees
where salary > (select avg(salary) from
employees))
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Hi Can any one tell me what are the API's used in requisition import.
What is a tns service name?
What is a dynamic performance view in oracle?
if you ctreate table identity
What are operators in oracle?
What happens to indexes if you drop a table?
What is oracle in java?
What is a proxy class?
What are the differences between number and binary_float in oracle?
What do you mean by a tablespace?
Can we protect our pl/sql source code?
Explain an index segment?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to rename an existing table?
How to define a cusotmer as a supplier in ORACLE R12
