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

What is primefaces used for?

1036

Explain compound trigger in oracle?

1019

Explain an exception?

971

How to rebuild an index in oracle?

1009

What to do if dba lost the system password?

1148

What are the differences between lov and list item?

1044

What is system global area (sga) in oracle?

968

What is max rowid in oracle?

1003

What are the different types of failures that occur in Oracle database?

1049

Explain the use of record option in exp command.

986

What is a sub query and what are the different types of subqueries?

1108

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2094

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4151

What is the difference between postgresql and oracle?

1021

Explain overloading. Can functions be overloaded?

964