SQL Interview Question | How to find all levels of Employee Manager Hierarchy | Recursion

How to install SQL Server for practice?
• How to install SQL Ser...
Another realtime scenario in which the same approach will be useful is finding the family tree.
Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
imp.i384100.net/qnXYk5
Data Science Fundamentals with Python and SQL Specialization
imp.i384100.net/mgVYre
Python for Everybody Specialization
imp.i384100.net/DVz7Aj
Google Data Analytics Professional Certificate
imp.i384100.net/OR37oQ
Coursera Plus - Data Science Career Skills
imp.i384100.net/c/3299742/132...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.com/company/know...
Email - [e-mail]

[@LearnatKnowstar]

Register at the below link to get US $100 off for Coursera Plus membership between Sep 8 - Sep 29, 2022.
The Coursera Plus membership gets you access to unlimited courses and unlimited certifications!
imp.i384100.net/Ke51on

[@mummz3371]

Thank you for your video and the great explanation. I really enjoy watching your videos❤️

[@kristyowens2284]

Very easy to follow. Beautifully explained!

[@LearnatKnowstar]

Thank you

[@rickrogers615]

Thank you so much for sharing this video! I really appreciate your pacing of the video where it is easy to follow. One question, how can you just out put each manager hierarchy level for all employees by column. For example, column shows all rows with the manager level of one. The second column would list all employees with the second hierarchy level and so on. I am trying to build self adjusting hierarchy level columns for use in a Power BI model where teams can change their parent team id or have new teams created or others made in active. Thank you!

[@LearnatKnowstar]

Thank you. You might need to filter on employee level to select the required columns or you might be able to use pivot for your requirements. Below is the link for sql pivot tutorial which might be useful.
ruclips.net/video/uT_Z2VP2Z24/видео.html

[@user-ld1dw9so3i]

we have our Mam Foqia khan, whose voice is totally like you and she is also a DBA.🤗

[@zuhebkhan6973]

Thanks for all ur support in sharing knowledge... Ma'am just a request I'm new to Sql world..... Plse prepare some videos on procedure with great example as its good becoz lots of questions were asked in interviews
Thanks in advance
Zuheb

[@LearnatKnowstar]

Thank you. We are planning a video soon. Stay tuned!

[@balajiveerasingam3602]

Thanks for sharing your knowledge. It help us really

[@LearnatKnowstar]

Glad to hear that. Thank you.

[@arnohoedelmans]

Hi can you do a video explaining how to get the hierarchy structure for every employee on one row?
Thank you very much!

[@satishsharmaphotography]

hey, ive been trying to solve this, for a table containing 2600 employees. but in my case, theere is no emp id with null manager id. what to do in that case.

[@svenkatjkn]

Beautifully explained!

[@LearnatKnowstar]

Glad it was helpful!

[@saurabhpandey1064]

where can we find the database for practicing this ? can you please attach a link .
Your videos are very helpful in preparation.

[@hv0032113]

Thank you for the great explanation.

[@LearnatKnowstar]

Thank you so much.

[@lalithroy]

Hi Mam,
Where can i get the data to practice. Or you can share the SQL script.

[@swapnaguthi8413]

Nice explanation.. Thanks for sharing

[@LearnatKnowstar]

Thanks so much!

[@dimpyrathore818]

Awesome explanation

[@LearnatKnowstar]

Thanks so much!

[@vishwas22khare]

Very nice explanation

[@LearnatKnowstar]

Thank you

[@jojog2624]

Nice tutorials!
Could you share your demo table data if possible, AdventureWorks sample data I downloaded from microsoft also have difference from yours...

[@LearnatKnowstar]

Thank you. Will try to share the DDLs in upcoming videos!

[@johnalfredbulado5272]

can you show your table ? thank you

[@_SanchitaPatil]

can we solve it using rank or denserank?

[@GDchanaka-he7qr]

good explanation. Thank you.

[@LearnatKnowstar]

Glad it was helpful!

[@asholkkumar4685]

Query optimization explain in further videos.thanks for ur great time.

[@LearnatKnowstar]

Thank you

[@gobind289]

There is a concept called heirarchyId. Which is more optimized way for large data set. Please make a video on this

[@LearnatKnowstar]

Thank you for mentioning this concept. Video coming in next few weeks🙏

[@aditidutt6328]

Thanks for this video, How can we find employees who are not having any reportee(parents having no child)

[@LearnatKnowstar]

you can do a left join on a.empid = a1.mgrid and filter where mgrid is null.

[@khushik8994]

Thank u so much for this video. I have a doubt. In 1st query of CTE, we are mentioning condition where managerID is null then how it is running for all managerID which is not null. Could you please let me know where my understanding is wrong

[@LearnatKnowstar]

The second part of the query after UNION ALL fetches the employees where manager id is not null. This is an example of recursive query.
This is another tutorial based on SQL recursion. You might find it helpful.
ruclips.net/video/d6OL9eDUhCE/видео.html
We will plan to post a separate tutorial explaining recursive queries. Thank you.

[@khushik8994]

@@LearnatKnowstar Thank u soo much for the detailed explanation...

[@Adinasa2]

Can someone do this in python

[@inhlam5909]

Level: Hard.