Interested to Buy Any Domain ? << Click Here >> for more details...
i want department wise maxmum salary and empolyee name
- 9 Answers
- 30100 Views
- I also Faced
- E-Mail Answers
Answer Posted / ajaikumar
Select e.ename, d.deptname, e.sal
from emp e, dept d
where
e.deptno = d.deptno
and
e.sal IN (
select max(sal) from emp
group by deptno
)
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
How to create a new table in your schema?
What happens to the indexes if a table is recovered?
Does facebook use oracle?
Explain about functional dependency and its relation with table design?
What is a cognitive schema?
Can multiple cursors being opened at the same time?
How do I find my oracle client driver version?
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.
Can group functions be mixed with non-group selection fields?
What to do if the startbd.bat failed to start the xe instance?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is a system tablespace and when it is created?
How to rebuild an index in oracle?
How can we view last record added to a table?
How do we get field details of a table?
