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
- 17159 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
How to Truncate Table in Oracle
In what script is snap$ created? In what script is the scott/tiger schema created?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is user managed backup in Oracle?
What is pragma autonomous transaction in oracle?
What is an oracle data file?
Explain the types of exception?
Give the constructs of a package, function or a procedure.
How to use subqueries with the exists operator in oracle?
can u plz provide me oca sql dumps please i need them
What is the meaning of recursive hints in oracle?
How to download oracle database 10g xe?
How to use regular expression in pattern match conditions in oracle?
