i want department wise maxmum salary and empolyee name
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
What is catalog in Oracle?
What is the Tune Query
What happens in oracle commit?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is the relation of a user account and a schema?
How to write date and time interval literals in oracle?
What happens if the update subquery returns multiple rows?
Which is faster join or subquery in oracle?
State the various uses of dbcc command?
What is the meaning of recursive hints in oracle?
What is execute immediate in oracle?
Give the advantages and disadvantages of clusters.
Give the various exception types.
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is an oracle user role?