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
- 17378 Views
- I also Faced
- E-Mail Answers
Answer Posted / sehajshangari1235
select distinct m.ename from emp e,emp m
where m.sal>(select avg(e.sal) from emp e,emp m where
e.mgr=m.empno);
call back for more
7204719446
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is redo log?
What is the best way to do multi-row insert in oracle?
Query to retrieve record for a many to many relationship ?
What is data type in oracle?
Which environment variables are absolutely critical in order to run the OUI?
what is the scripts in data base?
What is an oracle?
What is dynamic proxy?
What are the advantages of oracle?
types of indexes and the rationale behind choosing a particular index for a situation.
Can we protect our pl/sql source code?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
How can we delete duplicate rows in a table?
What is merge in oracle?
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
