Error: 1111 - SQLSTATE: HY000 ER_INVALID_GROUP_FUNC_USE
Description:
Message: Invalid use of group function
MySql-Server #1111 error in sql, '[microsoft][odbc sql server driver]unspecified error occurred on sql server. connection may have been terminated by the server', connection may have been terminated by the server. [sqlstate hy000], error 1111 sql, error: 1111 sqlstate: hy000 (er_invalid_group_func_use), error: [microsoft][odbc sql server driver] unspecified error occurred on sql server. connection may have been terminated by the server.state id hy 000, error: [microsoft][odbc sql server driver]unspecified error occurred on sql server. connection may have been terminated by the server., er_invalid_group_func_use, hy000 (er_invalid_group_func_use), hy000 :[microsoft][odbc sql server driver] unspecified error occurred on sql server. connection may have been terminated by the server, hy000 uspecified error occure in sql server, lrm-00118: syntax error at '=' at the end of input, microsoft odbc sql server driver unspecified server occurred, mysql "sql error (1111)", odbc error hy000 unspecified error, odbc sql server driver]unspecified error occurred on sql, sql error: 1111, sqlstate: hy000 invalid use of group function, sql server driver unspecified error, the following odbc error occurred: error: [microsoft][odbc sql server driver]unspecified error occurred on sql server. connection may have been terminated by the server. state id: hy000, ]unspecified error occurred on sql server. connection may have been terminated by the server
Make sure that GROUP BY is used to list all the columns in the SELECT clause that are not in aggregate functions. If you want to filter results returned by an aggregate function, use a HAVING clause just after the GROUP BY clause.