Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
- 6 Answers
- 14992 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 integrity constraint?
What is integrity and what is constraint??Explain with example
Explain user account with reference to oracle.
What happens to the current transaction if a ddl statement is executed?
How to store pictures on to the database?
How to define a variable to match a table column data type?
State and explain about oracle instance?
How to export data with a field delimiter?
What is a partition in oracle?
How to get maxsal , minsal, ename department wise in single query
What are the types of partitions in oracle?
Can we call procedure inside function in oracle?
How can you use check constraints for self referential integrity?
Explain how are indexes update?
what is IDE,DMV in sql server?
