Answer for Still get an error message in Duplicate Records lesson

https://365datascience.com/dwqa-answer/answer-for-still-get-an-error-message-in-duplicate-records-lesson/ -

Hi Yunfeng!

Thanks for reaching out.

Please make sure to reconnect to the server after you execute the relevant SET Statement. Then, the code is indeed correct. 

To sum up, here’s the order in which you need to execute the relevant operations, the second one being pressing the icon that has been underlined in red on the picture below.

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

SELECT 
m.dept_no, m.emp_no, d.dept_name
FROM
dept_manager_dup m
JOIN
departments_dup d ON m.dept_no = d.dept_no
GROUP BY m.emp_no
ORDER BY dept_no;

Hope this helps.
Best,
Martin

#365datascience #DataScience #data #science #365datascience #BigData #tutorial #infographic #career #salary #education #howto #scientist #engineer #course #engineer #MachineLearning #machine #learning #certificate #udemy