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
- 17014 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
Differentiate between post-database commit and post-form commit?
How to create a new user account in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is an external table?
What is the difference between Delete, Truncate and Drop in Oracle?
What is proxy method?
How to create an oracle database?
What is integrity and what is constraint??Explain with example
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to login to the server without an instance?
What do you understand by a database object?
What happens if recursive calls get out of control?
What is the minimum client footprint required to connect c# to an oracle database?
Why do you create or replace procedures rather that drop and recreate.
What is a read only transaction in oracle?
