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?
1 answers ( 0 marked as helpful)
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