Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
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
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
How to shutdown your 10g xe server?
How to login to the server without an instance?
 What are the oracle DML commands possible through an update strategy?
How can I create database in oracle?
What is dual table oracle?
What are the set operators union, union all, minus & intersect meant to do?
Explain about achiever in sql?
How does Oracle guarantee data integrity of data changes?
What are the database administrators utilities available?
Is oracle the best database?
What is oracle datasource?
What is a oracle database?
Which is better Oracle or MS SQL? Why?
How many anonymous blocks can be defined?