Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
Answer Posted / chakradhar
select ename,sal,mgr
from emp mgr
where sal > (select avg(sal)
from emp emp
where emp.mgr = mgr.empno)
Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
How to create a stored program unit?
Is it possible to insert comments into sql statements return in the data model editor ?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is the sid in oracle?
What are the oracle differences between nvl and coalesce
How to connect to the server with user account: sys?
How to list all tables in your schema?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What is the implicit cursor in oracle?
How to loop through data rows in the implicit cursor?
What are the execution control statements in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How remove data files before opening a database?
Which environment variables are absolutely critical in order to run the OUI?
How to shutdown your 10g xe server?