Last answered:

21 Dec 2022

Posted on:

20 Dec 2022


Error msg when applying the same code

when I apply  the same code you applied in this lec I get this error msg "Error Code: 1140. In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'employees.e.first_name'; this is incompatible with sql_mode=only_full_group_by"

1 answers ( 0 marked as helpful)
Posted on:

21 Dec 2022


Hi Anas!
Thanks for reaching out.

You need to run this code:
set @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');
Then, you have to restart the Workbench in order to save the new settings.

Hope this helps.

Submit an answer