Data Analyst SQL Interview Question |Self-Joins Explained

Welcome to our deep dive into the world of SQL Self-Joins! 🌍🔍 In this tutorial, we unravel the intricacies of self-joins, a powerful SQL technique often surrounded by confusion. Whether you're a beginner trying to grasp the fundamentals or an intermediate looking to solidify your understanding, this video is tailored for you.

[@ngocbao2436]

Thank you

[@asnaeb-er3wz]

I'm having a hard time understanding this one, is there another table with the managers name and the number of reports? Also, when you create e1 and e2 are these instances of the same table? Thx

[@ladhkay]

Yes hence the self. You're joining the table with itself

[@asnaeb-er3wz]

Thank you for the clarification! ​@@ladhkay

[@ravitejateju]

Em labham😂 ayipaye…

[@ganeshsarade9108]

Select e1.emp_name as employees_name, e2.emp_name as manager_name From employee e1 join employee e2 On e1.manager_id = e2.emp_is

[@absentdata]

Ok