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

Подписаться 44 тыс.

Просмотров 29 тыс.

50% 1

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 - learn@knowstar.org

Опубликовано:

27 сен 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 42

@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 2 года назад

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

@kristyowens2284 2 года назад

Very easy to follow. Beautifully explained!

@LearnatKnowstar 2 года назад

Thank you

@svenkatjkn Год назад

Beautifully explained!

@LearnatKnowstar Год назад

Glad it was helpful!

@user-ld1dw9so3i 10 месяцев назад

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

@hv0032113 2 года назад

Thank you for the great explanation.

@LearnatKnowstar 2 года назад

Thank you so much.

@balajiveerasingam3602 2 года назад

Thanks for sharing your knowledge. It help us really

@LearnatKnowstar 2 года назад

Glad to hear that. Thank you.

@dimpyrathore818 2 года назад

Awesome explanation

@LearnatKnowstar 2 года назад

Thanks so much!

@swapnaguthi8413 2 года назад

Nice explanation.. Thanks for sharing

@LearnatKnowstar 2 года назад

Thanks so much!

@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uT_Z2VP2Z24.html

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

@GDchanaka-he7qr Год назад

good explanation. Thank you.

@LearnatKnowstar Год назад

Glad it was helpful!

@saurabhpandey1064 2 года назад

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

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

@johnalfredbulado5272 2 года назад

can you show your table ? thank you

@asholkkumar4685 2 года назад

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

@LearnatKnowstar 2 года назад

Thank you

@lalithroy 2 года назад

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

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

@_SanchitaPatil 10 месяцев назад

can we solve it using rank or denserank?

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

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

@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 Год назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-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...