select ename,sal,deptno from emp where (deptno,sal) in (select deptno,max(

i want department wise maxmum salary and empolyee name

Question Posted / sanjay pradhan

Answer Posted / sanjay pradhan

select ename,sal,deptno from emp where (deptno,sal) in
(select deptno,max(sal) from emp group by deptno);

Is This Answer Correct ?

15 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to write numeric literals in oracle?

1163

what is the scenario where you take the database to NoArchivelog mode?

2304

Â What are the oracle DML commands possible through an update strategy?

1042

Explain what are clusters?

1087

How do you find current date and time in oracle?

1029

Are truncate and delete commands same? If so why?

1129

How does oracle handle read consistency?

1076

What is a table index?

1071

How to drop an index in oracle?

1051

Is it possible to insert comments into sql statements return in the data model editor ?

2536

What is an oracle user role?

967

11. Display the client number and name and the client number and name of the person who referred that client.

2321

What is oracle sid?

939

Explain the characteristics of oracle dba?

1103

What is materialized view in Oracle?

1059