GROUP BY clause; this is incompati

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

15 votes163 views5 answers
Show tables in oracle
SQL
0 vote101 views1 answer
Update set with join pl sql
SQL
10 votes150 views1 answer
Oracle dependencies table
SQL
0 vote161 views1 answer
Sql from null to not null
SQL
3 votes146 views1 answer
Locate sql server
SQL
4 votes143 views1 answer
Wildcard in sql
SQL
0 vote142 views1 answer
Get duplicate entry sql
SQL
0 vote148 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote145 views1 answer
What does leave do in mysql
SQL
13 votes285 views4 answers
Sql joining 3 tables
SQL