Resolved: about using manager_id as 10022
when I M USING 10022 as manager_ID in query A .why mysql showing manager_id as null?
2 answers ( 1 marked as helpful)
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Hi Ayush Sahu,
Without seeing the code\screen shot for your issue with the query, the only 'hint' I got from your comment is that the 'manager_ID' number that is to be used is 110022, not '10022' which is an 'employee_ID'. Copy of screen shot from video to help you verify - if this does not fix the issue, reply with a screen shot and I will review again.
Hope this helps.
Regards,
Kev T.
Hi Ayush!
Thanks for reaching out.
As Kev said the 'manager_ID' number that is to be used is 110022
, not 10022
which is an 'employee_ID'
Hope this helps.
Best,
Tsvetelin
Submit an answer
related questions
15. sql subquires--Can you please help to find out why in the video you are using the dept_emp table