ORA-00937 error

bkm_75 · #1 (**permalink**) 12-10-04, 04:14

I want to lis the dept with the smalles cumulative salary. I tried the foll query in Oracle

Select deptno, min(sum(sal))
from emp
group by deptno;

I get the foll error message

ORA-00937 error: Not a single group group function

What is wrong here? Please help!

r937 · #2 (**permalink**) 12-10-04, 06:20

i love that error number!!

what is wrong is that you cannot nest aggregate functions like that

i don't do oracle but i think the answer is something like:

Code:

select dept
     , sumsal as minsumsal
  from (select dept
             , sum(sal) as sumsal)
          from emp
        group
            by dept
        order
            by sum(sal) asc)
 where rownum=1

Internet Services

Web Development

Digital Marketing

Consumer Tech