Group by query only_ FULL_ GROUP_ By error

The ONLY_FULL_GROUP_BY error in the Group by query

The initial version of mysql for Windows (5.7.28) was used in the project, but later when migrating to Linux, some SQL queries experienced the error ONLY_FULL_GROUP_BY, because MySQL5.7 default set mysql SQL_mode = ONLY_FULL_GROUP_BY attribute, which caused an error (Windows version has no default).
MySQL also provides an any_value() function to suppress ONLY_FULL_GROUP_BY if the business must use a non-grouped field


Read More: