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
- 17129 Views
- I also Faced
- E-Mail Answers
Answer Posted / saiprasanna
select ename,empno from emp a where sal>(select avg(sal) from emp b where mgr=a.empno);
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain the use of consistent option in exp command.
What is meant by joins? List out the types of joins.
How to get execution path reports on query statements?
What is logical backup in oracle?
How to create a new oracle data file?
What are the attributes that are found in a cursor?
What is oracle rowcount?
What are the logical operations?
What is the disadvantage of User defind function?
What is a trigger and what are its types?
Please explain oracle data types with examples?
Is rowid unique in oracle?
Explain oracle instance.
What is a relational database management system?
How to define an explicit cursor in oracle?
