Last answered:

09 Feb 2022

Posted on:

01 Feb 2022

1

Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated

Error showing for sql code at 2:06



Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'employees.dept_emp.from_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

1 answers ( 0 marked as helpful)
Instructor
Posted on:

09 Feb 2022

6

Hi Erumpent!
Thanks for reaching out.
Please, run the following query:

set @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');

Then, restart the Workbench. The issue should be resolved.

Hope this helps.
Best,
Tsvetelin

Submit an answer