Yes you might be using group functions incorrectly .. Just post your SELECT query which you are using and which is throwing errors as i guess problem is you are not making use of nested functions properly so first post your query ..
SELECT SUM((AVG(LENGTH(NVL(SALARY,0))))) FROM EMPLOYEE
Rahul India wrote:Because you have nested aggregate functions (in this case, the aggregate AVG function is nested inside the aggregate SUM function), but you don't have a GROUP BY clause.
When i remove the group by clause it throws an errorwhy this error occurs?
ORA-00978: nested group function without GROUP BY