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
- 16797 Views
- I also Faced
- E-Mail Answers
Answer Posted / pradeep
select ename,sal,mgr
from emp a
where sal > (select avg(sal)
from emp b
where b.mgr = a.mgr)
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
How to add a new column to an existing table with a default value?
Query to retrieve record for a many to many relationship ?
How to create a table interactively?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
How to create an oracle database?
how the indexes are stored in the Oracle Database?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to insert multiple rows with one insert statement in oracle?
What is truncate oracle?
How to get the Installed Oracle Version Information ?
What is a named program unit?
Is primary key indexed by default in oracle?
How to use subqueries in the from clause in oracle?
How to pass a parameter to a cursor in oracle?
