/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

5 votes314 views1 answer
Oracle sysdate - 1 month
SQL
25 votes309 views6 answers
Sql update query
SQL
5 votes330 views1 answer
Purge undo tablespace usage
SQL
0 vote339 views1 answer
Database schema for mcqs type exam in sql
SQL
3 votes301 views1 answer
Postgres update column with value from another table
SQL
0 vote314 views1 answer
How to select a row in sql
SQL
0 vote290 views1 answer
Sql database size
SQL
0 vote317 views1 answer
Authentication in sql server
SQL
0 vote301 views1 answer
Casterar postgres
SQL
11 votes331 views2 answers
Oracle saurce code
SQL