/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 vote253 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote263 views1 answer
Mysql query problems and solutions
SQL
0 vote273 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote258 views1 answer
Oracle execute package dblink
SQL
5 votes285 views3 answers
Show indexes mysql
SQL
0 vote294 views1 answer
How to move a columns location in mysql
SQL
0 vote253 views1 answer
Mysql:5.6 syntax create table
SQL
10 votes265 views4 answers
Inner join in update query mysql
SQL
11 votes282 views3 answers
How to get last row of table in sql
SQL
0 vote259 views1 answer
How to check even or odd in sql
SQL