The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

duplicate values error code from SQL course.

duplicate values error code from SQL course.

0
Votes
1
Answer

towards the end of the lecture, we add a group by m.emp_no into the inner join we made in the previous lesson to filter out duplicate values, I am getting an error code for 1055. I have ran the code mentioned before diving into joins, but I am not sure what else I need to do make sure it can run correctly.
 
SELECT
m.dept_no, m.emp_no, d.dept_name
FROM
dep_manager_dup m
INNER JOIN
departments_dup d ON m.dept_no = d.dept_no
group by m.emp_no
ORDER BY dept_no;
 
here is what I have when I attempt to run the code.

1 Answer

365 Team
0
Votes

Hi Alan!
Thanks for reaching out.
Please go back to the Important – Prevent Error Code: 1055! note and execute the code in it as suggested.
https://365datascience.teachable.com/courses/360102/lectures/11680913
Hope this helps but please get back to us should you need further assistance. Thank you.
Best,
Martin
 
 

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF