/SQL/Expression number 1 of select list is not in group by clause

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

3 votes297 views2 answers
Postgresql select all column names
SQL
2 votes284 views1 answer
How to add where command in update comand with joins
SQL
0 vote325 views2 answers
Port 5432 is already in use mac
SQL
0 vote298 views1 answer
Select into table variable
SQL
3 votes256 views1 answer
If 0 return null else return query mysql
SQL
0 vote335 views1 answer
Sql query inline if
SQL
2 votes283 views1 answer
Alter table add multiple columns postgresql
SQL
2 votes283 views1 answer
Sqlite show table indexes
SQL
1 vote304 views1 answer
Mysql check table exists
SQL
0 vote307 views1 answer
Where date major today mysql
SQL