/SQL/Select list is not in group by clause

Select list is not in group by clause

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Source: stackoverflow.com

Expression number 1 of select list is not in group by clause

mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

Source: stackoverflow.com

Similar codes

1 vote167 views1 answer
Sql drop with dependencies
SQL
0 vote123 views1 answer
How to get last client id sql
SQL
0 vote180 views1 answer
Sql change column in existing table
SQL
16 votes235 views4 answers
Find duplicates mysql
SQL
0 vote184 views1 answer
Sql server concat null
SQL
4 votes201 views3 answers
Sqlite show columns
SQL
0 vote184 views1 answer
Make parameters nullable in sql server
SQL
0 vote249 views2 answers
How to prevent sql injection in java
SQL
0 vote194 views1 answer
Check constraint is violated
SQL
0 vote208 views1 answer
Basic structure of sql expression having clause
SQL