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 are the various oracle database objects?

1127

Why does for update in oracle 8 cause an ora-01002 error?

983

How to create additional tablespaces for an new database?

1010

Is insert autocommit in oracle?

1055

How to upsert (update or insert into a table)?

985

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2281

Explain an extent?

1085

How to connect to a local oracle 10g xe server?

976

Is oracle a programming language?

969

What suggestions do you have to reduce the network traffic?

938

What happens if recursive calls get out of control?

1060

How can we find out the duplicate values in an oracle table?

1032

How do we create privileges in oracle?

1029

What are the ansi data types supported in oracle?

935

How to call a sub procedure?

1074