/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

0 vote231 views2 answers
Mysql disable foreign key checks
SQL
0 vote236 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote247 views1 answer
Sql server Cost Fifo query
SQL
0 vote251 views2 answers
Raise notice in postgresql function
SQL
0 vote224 views1 answer
Like and not like together in sql
SQL
1 vote221 views1 answer
Can not connect to mysql server
SQL
33 votes232 views2 answers
Postgres how to add field created at
SQL
0 vote260 views1 answer
Yesql
SQL
0 vote234 views1 answer
Sql insert from excel
SQL
2 votes242 views3 answers
Postgres create view
SQL