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

No video

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

Рет қаралды 30,083

Күн бұрын

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.
Must Do Data Analytics Certifications -
Google Data Analytics Professional Certificate
imp.i384100.ne...
Google Advanced Data Analytics Professional Certificate
imp.i384100.ne...
Practice SQL Queries on Your Browser through Interactive Courses -
learnsql.com/?...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Blog - know-star.blogs...
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org

Пікірлер: 42

@LearnatKnowstar 2 жыл бұрын

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

@user-ld1dw9so3i Жыл бұрын

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

@kristyowens2284 2 жыл бұрын

Very easy to follow. Beautifully explained!

@LearnatKnowstar 2 жыл бұрын

Thank you

@zuhebkhan6973 2 жыл бұрын

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 2 жыл бұрын

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

@vishwas22khare 2 жыл бұрын

Very nice explanation

@LearnatKnowstar 2 жыл бұрын

Thank you

@rickrogers615 2 жыл бұрын

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 2 жыл бұрын

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. kzfaq.info/get/bejne/q7qPjZWHtZi-Ymg.html

@balajiveerasingam3602 2 жыл бұрын

Thanks for sharing your knowledge. It help us really

@LearnatKnowstar 2 жыл бұрын

Glad to hear that. Thank you.

@mummz3371 2 жыл бұрын

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

@dimpyrathore818 2 жыл бұрын

Awesome explanation

@LearnatKnowstar 2 жыл бұрын

Thanks so much!

@svenkatjkn 2 жыл бұрын

Beautifully explained!

@LearnatKnowstar Жыл бұрын

Glad it was helpful!

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

@arnohoedelmans 2 жыл бұрын

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

@asholkkumar4685 2 жыл бұрын

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

@LearnatKnowstar 2 жыл бұрын

Thank you

@aditidutt6328 2 жыл бұрын

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

@LearnatKnowstar 2 жыл бұрын

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

@GDchanaka-he7qr Жыл бұрын

good explanation. Thank you.

@LearnatKnowstar Жыл бұрын

Glad it was helpful!

@jojog2624 2 жыл бұрын

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

@LearnatKnowstar 2 жыл бұрын

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

@hv0032113 2 жыл бұрын

Thank you for the great explanation.

@LearnatKnowstar 2 жыл бұрын

Thank you so much.

@saurabhpandey1064 2 жыл бұрын

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

@swapnaguthi8413 2 жыл бұрын

Nice explanation.. Thanks for sharing

@LearnatKnowstar 2 жыл бұрын

Thanks so 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.

@_SanchitaPatil Жыл бұрын

can we solve it using rank or denserank?

@khushik8994 2 жыл бұрын

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 2 жыл бұрын

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. kzfaq.info/get/bejne/mpx_f5yWqbvMc3k.html We will plan to post a separate tutorial explaining recursive queries. Thank you.

@khushik8994 2 жыл бұрын

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