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

[@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

[@MuhammadZeeshan-q3l]

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

[@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. kzbin.info/www/bejne/q4XCi2WMhZeNaJY

[@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.

[@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!

[@vishwas22khare]

Very nice explanation

[@LearnatKnowstar]

Thank you

[@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!

[@svenkatjkn]

Beautifully explained!

[@LearnatKnowstar]

Glad it was helpful!

[@Beyondhorizons-i5z]

Awesome explanation

[@LearnatKnowstar]

Thanks so much!

[@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.

[@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🙏

[@saurabhpandey1064]

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

[@mummz3371]

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

[@_SanchitaPatil]

can we solve it using rank or denserank?

[@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!

[@lalithroy]

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

[@GDchanaka-he7qr]

good explanation. Thank you.

[@LearnatKnowstar]

Glad it was helpful!

[@johnalfredbulado5272]

can you show your table ? thank you

[@asholkkumar4685]

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

[@LearnatKnowstar]

Thank you

[@hv0032113]

Thank you for the great explanation.

[@LearnatKnowstar]

Thank you so much.

[@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. kzbin.info/www/bejne/mmeyfWybebqbeac We will plan to post a separate tutorial explaining recursive queries. Thank you.

[@khushik8994]

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

[@swapnaguthi8413]

Nice explanation.. Thanks for sharing

[@LearnatKnowstar]

Thanks so much!

[@inhlam5909]

Level: Hard.

[@Adinasa2]

Can someone do this in python