Self Join SQL Tutorial with Example

Рет қаралды 60,085

Big Tech Mindset

Күн бұрын

Пікірлер: 57

@Sylarleft Жыл бұрын

Finally a decent explanation of when would a Self Join be useful!

@bigtechmindset Жыл бұрын

Thank you for the feedback!

@maythom 3 жыл бұрын

All I can say is that you explain better than my professor!

@bigtechmindset 3 жыл бұрын

I appreciate the support, thank you.

@MrDammed1 Жыл бұрын

didnt expect a 5 minute sql video to be so helpful and informative

@bigtechmindset Жыл бұрын

Thank you for the kind words!

@r.lum.r Жыл бұрын

damn this explains it in a way that I understand. Thank you for using a realistic use case, as well. I think I could actually do this.

@bigtechmindset Жыл бұрын

I appreciate the kind words brother! I'm happy you found it helpful

@vf1764 Жыл бұрын

Excellent explanation, thanks! The w3schools explanation for this was bit vague and confusing, this was very clear.

@bigtechmindset Жыл бұрын

Glad it was helpful! Thank you for watching

@kishorekumar2769 3 жыл бұрын

Excellent! I've tried a few videos to understand self join, but this tutorial has been much more helpful. Thank you!

@bigtechmindset 3 жыл бұрын

Thanks for watching. I have a few videos on sql interview problems using self join as well if that helps!

@name1927 Жыл бұрын

👍🏻agree

@RafaelJaureguiCaball 2 жыл бұрын

IS THERE SUCH A THING AS A SELF JOIN NOT INDICATING LEFT OR RIGHT?

@seymur.halley Жыл бұрын

Underrated video!

@bigtechmindset Жыл бұрын

Thank you for the kind words!

@metquadi Жыл бұрын

very easy to understand. thank you

@bigtechmindset Жыл бұрын

I am humbled you found it helpful! Thank you for the feedback

@arunkumaracharya9641 3 жыл бұрын

All I needed was a result at 2.53.....like what will be the result of the complete left join. Clearly, there are tons of examples on the internet, but none showed the result of joining. They just filtered it to two columns based on question/use case. WHich means they themselves learned it by heart without logic. You showed it clearly what happens in the background. Thank you

@bigtechmindset 3 жыл бұрын

Thank you Arun for the valuable feedback! I'm happy you found it helpful.

@juancruz151 3 жыл бұрын

Thank to you I could understand self joins. Thank you very much!

@bigtechmindset 3 жыл бұрын

Very welcome! Glad to help. Thanks for watching

@damian2955 3 жыл бұрын

Okay but still dunno why I would want to do it instead select emp_name, emp_id

@FatimaZahra-lh7ll 2 жыл бұрын

You want to get the supervisor name instead of an id.

@drawdownfx4415 Жыл бұрын

hey i used the on condition as emp.emp_id= supv.emp_supervisor_id , is that also okay or not? am slightly confused on that bit

@c0s1m4 Жыл бұрын

i am questioning the same, any idea?

@CaribouDataScience 2 жыл бұрын

Thanks, your explanation makes perfect sense!!

@anunaysharma2098 3 жыл бұрын

Short and simple. thanks.

@ES11777 Жыл бұрын

Nice 👍

@bigtechmindset Жыл бұрын

Thanks!

@nopesalamandra9144 4 жыл бұрын

Thank you, tthis was very helpful!

@Simon_is_not_sure 2 жыл бұрын

Dude, thanks a lot - great tutorial :)

@bigtechmindset 2 жыл бұрын

Glad it helped!

@shaileshsingh1445 2 жыл бұрын

Well explained. For better understanding, it would be great if you also write down the problem statement for which we are writing the query for. I know you have verbally mentioned that. :)

@bigtechmindset Жыл бұрын

Noted, thank you!

@vanrock6754 2 жыл бұрын

i understand now, it's really easy but, i wonder that with more large fields and columns it gets tricky idk, Thank you so much for the tutorial

@Rose-93 2 жыл бұрын

It was wonderful! Thank you so much :))

@muhtasimahmed4771 3 жыл бұрын

Where is supervisor's name coming from ?

@bigtechmindset 3 жыл бұрын

It comes from the employee name field. Let's assume an Employee with employeeID is 1, and their supervisorID is 5. Using this join, we can look up employeeID 5, and that employee name would be the supervisor name for employeeID 1.