Last answered:

04 May 2024

Posted on:

13 Jul 2023


Error while trying to replicate within-lecture-code

Following is my attempt to d othe same code as in the lecture to remove the duplicates, but I got the error as you see. Any help?


2 answers ( 0 marked as helpful)
Posted on:

28 Sept 2023


Got the same error, tried resolving it by deleting ONLY_FULL_GROUP_BY option from server options file, but for some reason couldn't apply changes to the file. Then i solved the problem by simply stating every statement from SELECT part into GROUP BY

Posted on:

04 May 2024


Hi Saeed and Miro!

Thanks for reaching out.

Please accept my apologies for the delayed response.

@Miro: Thank you very much for sharing your solution with the Community !

@Saeed: Since programming is an area where multiple components of different type are necessary to be taken into account simultaneously, we believe there is value in not presenting all of it altogether but at the right moment throughout the course syllabus. That said, we discuss how to prevent error 1055 in the resources section of the following lecture:

Please refer to it for an explanation.

Hope this helps.

Submit an answer