Select e.ename, d.deptname, e.sal from emp e, dept d where e.deptno

i want department wise maxmum salary and empolyee name

Question Posted / ajaikumar

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

Please Help Members By Posting Answers For Below Questions

What is an oracle wallet?

942

What is primefaces used for?

1050

How to write a query with a left outer join in oracle?

1066

How to update values on multiple rows in oracle?

1035

How to create a temporary table in oracle?

1273

What is a tns file?

998

Explain the importance of .pll extension in oracle?

1013

State the various uses of dbcc command?

1060

What is merge in oracle?

1055

1) Does oracle have any table which contain all the exceptions and it's code internally?

1751

Briefly explain what is literal? Give an example where it can be used?

1045

What is the scope of a local variable?

1067

In what script is snap$ created? In what script is the scott/tiger schema created?

2710

What are the advantages of oracle?

1028

what is difference between sql plus and sql*plus? (not sql and sql plus).

3904