not a single-group group function? Oracle Community

Well, either you want a 'max' or an 'avg' function on each department_id. Two aggregate functions do not make sense in here. Please take off the one that is NOT needed and you should be good.
Sara singletary

not a single-group group function? Oracle Community

Re: Single group function

Using Group functions - Tutorials Point Group by function establishes data groups based on columns and aggregates the information within a group only. The grouping criterion is defined by the columns specified in GROUP BY clause. Following this hierarchy, data is first organized in the groups and then WHERE clause restricts the rows in each group.

not a single-group group function? Oracle Community

Re: Single group function

ORA- 00937: not a single-group group function tips Cause: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause.

not a single-group group function? Oracle Community

Re: Single group function

Oracle SUM - ORA-00937: not a single-group group function. Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community.

not a single-group group function? Oracle Community

Re: Single group function

kleine SQL-Hilfe benötigt: not a single-group group function Was moechtest Du denn ueberhaupt erreichen? Die avg() Funktion liefert die den Durchschnittswert aller Eintraege einer Spalte. Es kann nur einen Durchschnittswert geben, genauso wie es nur einen min und einen max-Wert geben kann.

not a single-group group function? Oracle Community

Re: Single group function

ORA-00937: not a single-group function - TekStream 1117 Perimeter Center West Suite E400 Atlanta, GA 30338. main directory fax

not a single-group group function? Oracle Community

Re: Single group function

Oracle PLSQL: ORA-00937 Error Message - TechOnTheNet Remove the GROUP BY function (ie: MIN Function, MAX Function, SUM Function, COUNT Function) from the SELECT statement. Option #3 Remove the expression from the SELECT list that was not in the GROUP BY clause.

not a single-group group function? Oracle Community

Re: Single group function

ORA-00937: not a single-group group function 'The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing.

not a single-group group function? Oracle Community

Re: Single group function

ORA-00937: not a single-group group function Solution. ORA-00937: not a single-group group function 00937. 00000 - 'not a single-group group function' This is because there is no GROUP BY clause, and you’re using an aggregate function (the SUM function) along with another field (department_id).

not a single-group group function? Oracle Community

Re: Single group function

Oracle Min - ORA-00937 not a single-group group function. Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.