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
- 17160 Views
- I also Faced
- E-Mail Answers
Answer Posted / pradeep
select ename,sal,mgr
from emp a
where sal > (select avg(sal)
from emp b
where b.mgr = a.mgr)
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
What is a trace file and how is it created in oracle?
Explain what are the type of synonyms?
What is open database communication (odbc) in oracle?
what are actual and formal parameters?
What are the uses of linked server and explain it in detail?
How to drop a stored procedure in oracle?
Which are the five query types available in oracle?
Will you be able to store pictures in the database?
What is the best way to do multi-row insert in oracle?
How to define and use table alias names in oracle?
How can Oracle users be audited?
What are the advantages of oracle?
What are the various types of snapshots ?
How to delete all rows a table in oracle?
What are the ways tablespaces can be managed and how do they differ?
