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
- 16796 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
How to use existing values in update statements using oracle?
How to connect to the server with user account: sys?
How to pass parameters to procedures in oracle?
What is the difference between hot backup and cold backup in oracle?
How to empty your oracle recycle bin?
What do you mean by merge in oracle?
How to see free space of each tablespace?
Can multiple columns be used in group by in oracle?
How to use subqueries with the exists operator in oracle?
What is a synonym? What are its various types?
What privilege is needed for a user to create views in oracle?
What is tns service name?
What is oracle latest version?
What are the tools for Oracle ?
How to define a data field as not null?
