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

i want department wise maxmum salary and empolyee name

Question Posted / shiva

Answer Posted / shiva

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

Is This Answer Correct ?

0 Yes

7 No

Please Help Members By Posting Answers For Below Questions

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1939

How to revoke create session privilege from a user in oracle?

962

Can the query output be sorted by multiple columns in oracle?

936

What is the sql query to concatenate column values from multiple rows in oracle?

999

How to drop an existing table in oracle?

1015

What are the original export and import utilities?

1058

What is oracle join syntax?

945

What is the recommended interval at which to run statspack snapshots, and why?

2861

Explain what are synonyms used for?

983

What happens to indexes if you drop a table?

1112

Is there a combination of "like" and "in" in sql?

1007

How data locks are respected in oracle?

1013

Explain the use of constraints option in exp command.

992

Explain the use of file option in exp command.

1081

Explain enable novalidate constraint.

1035