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
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
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!
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. th-cam.com/video/uT_Z2VP2Z24/w-d-xo.html
Nice tutorials! Could you share your demo table data if possible, AdventureWorks sample data I downloaded from microsoft also have difference from yours...
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.
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
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. th-cam.com/video/d6OL9eDUhCE/w-d-xo.html We will plan to post a separate tutorial explaining recursive queries. Thank you.
![[#SHORTS CLIP] ใช้ของของตัวเองไปเลยสิคะ l ซานิเบาได้เบา l One Playground](http://i.ytimg.com/vi/Ea_mTywx2p4/mqdefault.jpg)
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
Very easy to follow. Beautifully explained!
Thank you
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
Thank you. We are planning a video soon. Stay tuned!
we have our Mam Foqia khan, whose voice is totally like you and she is also a DBA.🤗
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!
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.
th-cam.com/video/uT_Z2VP2Z24/w-d-xo.html
Thanks for sharing your knowledge. It help us really
Glad to hear that. Thank you.
Thank you for your video and the great explanation. I really enjoy watching your videos❤️
Very nice explanation
Thank you
Hi can you do a video explaining how to get the hierarchy structure for every employee on one row?
Thank you very much!
Thanks for this video, How can we find employees who are not having any reportee(parents having no child)
you can do a left join on a.empid = a1.mgrid and filter where mgrid is null.
Awesome explanation
Thanks so much!
There is a concept called heirarchyId. Which is more optimized way for large data set. Please make a video on this
Thank you for mentioning this concept. Video coming in next few weeks🙏
Nice tutorials!
Could you share your demo table data if possible, AdventureWorks sample data I downloaded from microsoft also have difference from yours...
Thank you. Will try to share the DDLs in upcoming videos!
Beautifully explained!
Glad it was helpful!
Query optimization explain in further videos.thanks for ur great time.
Thank you
where can we find the database for practicing this ? can you please attach a link .
Your videos are very helpful in preparation.
Thank you for the great explanation.
Thank you so much.
good explanation. Thank you.
Glad it was helpful!
Nice explanation.. Thanks for sharing
Thanks so much!
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.
can we solve it using rank or denserank?
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
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.
th-cam.com/video/d6OL9eDUhCE/w-d-xo.html
We will plan to post a separate tutorial explaining recursive queries. Thank you.
@@LearnatKnowstar Thank u soo much for the detailed explanation...
can you show your table ? thank you
Hi Mam,
Where can i get the data to practice. Or you can share the SQL script.
Level: Hard.
Can someone do this in python