both answers r wrong i want the greatest salaries group of sum(sal).

means if deptno 10 have sum(sal) 10000

20 have sum(sal) 15000

30 have sum(sal) 12000

i need answer is : 20 15000

beacause dept 20 have greatest sum.

Srinivas

select deptno max(sum(salary))

from EMP group by deptno;

I TAKE THE EMP AND DEPT TABLE FROM SCOTT AND TIGER.

SELECT * FROM (SELECT SUM(SAL)MAXSAL DEPT.DNAME FROM EMP DEPT WHERE EMP.DEPTNO DEPT.DEPTNO GROUP BY DNAME ORDER BY SUM(SAL)DESC )WHERE ROWNUM 1

To Get the Max sal of each department

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

Executed and tested in Oracle 8i :-

select * from (
select e.dept sum(e.sal) esal
from emp e dept d
where e.deptid d.deptid
group by e.deptid
order by sum(e.sal) desc
) where rownum 1;

select deptno sal1 from (select sum(sal) sal1 deptno from scott.emp group by deptno order by sal1 desc) where rownum < 1