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

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

Follow this topic

Mohammad Abdullah Ansari

Last answered:

09 Feb 2022

Posted on:

01 Feb 2022

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

in SQL / Using SQL views

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

09 Feb 2022

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

Submit an answer

related questions