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
- 17372 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
What is snapshot is too old? Give and example for better understand.
Explain oracle 12c new features for developers?
Difference between inner join vs where ?
What is blob datatype?
How to specify default values in insert statement using oracle?
How to write a query with a left outer join in oracle?
How do I reset a sequence in oracle?
What is the difference between $oracle_base and $oracle_home?
Explain oracle left join with an example?
What are the system predefined user roles?
What is a subquery?
Explain the use of owner option in exp command.
What is columnar storage what is the advantage?
How to start your 10g xe server?
What is an external table?
