Display those managers salary greater than the average
salary of his employees?(Based on oracle standard Emp table)
Answer Posted / sehajshangari1235
select distinct m.ename from emp e,emp m
where m.sal>(select avg(e.sal) from emp e,emp m where
e.mgr=m.empno);
call back for more
7204719446
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is oracle open database communication (odbc)?
What is snapshot is too old? Give and example for better understand.
What are dml statements in oracle?
Explain integrity constraints?
What is a cognitive schema?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
How to get a create statement for an existing table?
How to create a table in a specific tablespace?
How to save query output to a local file?
How to start a specific oracle instance?
What happens if the update subquery returns multiple rows?
Can we write insert statement in function in oracle?
How many types of cluster table in Oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Explain what are the advantages of views?