Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
Answer Posted / murali
select m.ename from emp e,emp m where e.mgr=m.empno and
e.sal<m.sal
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to use subqueries with the exists operator in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to loop through a cursor variable?
How to write a query with a right outer join in oracle?
How to define an external table with a text file?
How to start your 10g xe server from command line?
How many types of database triggers exist?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Explain self joins in oracle?
How to use an explicit cursor without open statements?
How do I recompile a procedure in oracle?
How to define an explicit cursor in oracle?
How to pass parameters to procedures?
What do you mean by a database transaction & what all tcl statements are available in oracle?
How to generate query output in html format?