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
- 17020 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 constraints option in exp command.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is a snapshot log?
How to declare a local variable?
What is the difference between a hot backup and a cold backup in oracle?
what is port in oracle? how is it related to database application.
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
State the various uses of dbcc command?
Define oracle database
How do I find my oracle client driver version?
How to divide query output into groups in oracle?
State any two functions of oracle?
How to use windows user to connect to the server?
What are the different types of synonyms?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
