/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 vote216 views1 answer
Sql mod even odd
SQL
10 votes174 views2 answers
Mysql select timestamp group by day
SQL
0 vote237 views1 answer
Mssql last day of month
SQL
0 vote237 views1 answer
Sql query interview questions githu
SQL
0 vote152 views1 answer
Ms sql print more than 1 variable
SQL
0 vote209 views1 answer
Get cpu details sql
SQL
0 vote259 views1 answer
Mysql trigger to delete old data
SQL
4 votes216 views1 answer
Oracle nls_date_format
SQL
0 vote211 views1 answer
Can we rollback data that are deleted using DELETE
SQL
1 vote353 views1 answer
Mysql data from file
SQL