Error 1140: Mixing of GROUP columns with no GROUP columns

Error Code
SQLSTATE
Error
Description

1140

42000

ER_MIX_OF_GROUP_FUNC_AND_FIELDS

Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Possible Causes and Solutions

This page is licensed: CC BY-SA / Gnu FDL

Last updated

Was this helpful?