Error 1140: Mixing of GROUP columns with no GROUP columns

Error CodeSQLSTATEErrorDescription
114042000ER_MIX_OF_GROUP_FUNC_AND_FIELDSMixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.