ORA-00979: not a GROUP BY expression when sum(col)

    SELECT INVOICEM.EMP_NO,EMPLOYEES.EMP_NAME,INVOICEM.INV_NO,SUM(INVOICEM.SUM_AMT),INVOICEM.SAL_DATE,INVOICEM.BRANCH
 FROM INVOICEM JOIN EMPLOYEES
ON INVOICEM.EMP_NO = EMPLOYEES.EMP_NO
GROUP BY INVOICEM.EMP_NO,EMP_NAME

Help me


Source: oracle

Leave a Reply