/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 vote103 views1 answer
SqlFunction does not exist
SQL
-1 vote111 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote112 views1 answer
Sql server remove primary key without dropping table
SQL
11 votes261 views4 answers
Round in sql
SQL
0 vote102 views1 answer
Apex for oracle 11g
SQL
2 votes108 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
0 vote111 views1 answer
View to table sql
SQL
2 votes105 views1 answer
Oracle to_char number format percentage
SQL
4 votes96 views1 answer
Sql group by year
SQL
0 vote104 views2 answers
List all the items that have not been part of any purchase order. sql
SQL