SQL Interview - Employee Manager Hierarchy - Self Join

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

[@LearnatKnowstar]

Have you been asked a SQL query interview question that you couldn't answer? Let us know in the comments below and we will answer those in our upcoming videos!

[@gagansingh3481]

Thank you mam for making such an amazing videos on sql , I have practice most of your videos of playlist 62 videos ..... Keep posting amazing videos

[@LearnatKnowstar]

Glad it was helpful 🙏

[@narayanagottipati5980]

Great video. Please upload this type of queries mam...Thanks

[@kristyowens2284]

very useful. I have been asked this question many times in interviews.

[@LearnatKnowstar]

Thank you

[@surajpatil3579]

Thank you... your content is truly informative

[@ujjwaltarway1438]

WoW simply wonderful😇

[@LearnatKnowstar]

Thank you

[@AK-rw8zq]

The Boss who's value is Null record not appeared in the output, please check once...

[@LearnatKnowstar]

It is because of the inner join. You can change it to a Left join to get the record in the output.

[@Sumit261990]

great video , Thanks

[@LearnatKnowstar]

Thank you

[@ravindrasutar7490]

thanks its really helpful

[@LearnatKnowstar]

Thank you

[@saradacosta2543]

How will you query to identify the circular references in employees and manager relationship?

[@lakshaysharma5012]

Thanks for the informative video. Also, can you help with the insert code for the data?

[@LearnatKnowstar]

Thank you

[@AbdullahAli-yq7wm]

If you share SQL query in the description would be so helpful

[@LearnatKnowstar]

We are sharing the queries in our most recent videos 👍

[@nikhilkumarchaudhary9593]

kindly share how to print this hierarchy in single column like --> adam->natasha->mark in single column

[@LearnatKnowstar]

Sure, will cover this in a future video.

[@manjeetrawat2351]

Use ..... group_concat But I think you have cleared your doubt

[@chu1452]

​@@LearnatKnowstar is the video uploaded already mam?

[@PujaKiPyaariDuniya]

Please make video for full hierarchy like parents ,son , Grand parents , grand children

[@LearnatKnowstar]

Thank you for your comment. You can find it here kzbin.info/www/bejne/iJ7PZIiObdOiZq8

[@koteswaribapatla8075]

please include source script in description, thanks

[@radhikasinhanwd]

can you help me solving a sql query for a database that contains three tables, AAID,cookies, IDAF Column Headers ● Id_type ○ AAID ○ IDFA ○ Cookie ● Device_id ● Hashed_email (SHA256) ● Timestamp ○ Unix timestamp ● Ip_address ● Opted_out ○ 1, 0 ○ 1 = opted out Querys are ● Where device_id appears more than once AND has ID type IDFA & AAID - Delete all ● IF hashed email matches more than 50 IDs (sum of cookie, idfa, aaid) - Delete all can this be deleted in single query?

[@suryakanthbhullha7425]

Thanks, if you added table populated script that will very helpful.

[@LearnatKnowstar]

Thank you. We have started adding table scripts to our latest videos.

[@kristidumais3458]

Thank you so much!!!

[@LearnatKnowstar]

Thank you.

[@priyankadevarapalli7295]

why is it not mentioned as self join in self join and mentioned as inner join?

[@LearnatKnowstar]

Self join is a type of inner join

[@hichamsabah31]

Table a inner join Table a means you are joining a table to itself, hence self-join.

[@harshamuniswamy162]

What is the difference between union and Superlative Union?

[@gudiatoka]

left join should be better as it skip top manager id with inner join

[@KishoreKumarKokkula]

You did for one level only, you can't get full & complete hierarchy with just one self join, if you can make it plz share

[@LearnatKnowstar]

You can find the tutorial for all levels here - kzbin.info/www/bejne/iJ7PZIiObdOiZq8

[@saileelavamsikrishna]

I was asked to find all direct and indirect subordinates with given manager name🤦🏻‍♂️

[@LearnatKnowstar]

Thank you. We will be posting a video soon to find the complete employee manager hierarchy.

[@cleversachin]

This is not hirearchy. hirearchy means a particular employee's entire hirearchy

[@shadabchoudhary6838]

Ek point ko smjhane k liye 50 line aap English bolti h aise kaise chalega madam try to speak in Hindi😅

[@shadabchoudhary6838]

Concept dekhe ya english smjhe tumhari😂