/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 vote204 views1 answer
Mssql unique key accept nulls
SQL
1 vote255 views1 answer
Sql check roles
SQL
2 votes140 views4 answers
2nd highest salary in mysql
SQL
0 vote138 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote130 views1 answer
Sql datediff month
SQL
0 vote128 views1 answer
How to find columns with null values in sql
SQL
1 vote128 views1 answer
Postgresql escape single quote
SQL
0 vote129 views1 answer
Oracle create table auto generated primary key
SQL
0 vote120 views1 answer
Mariadb maximum left join
SQL
0 vote129 views1 answer
How to import sqlite driver class in java using maven
SQL