Self Join in SQL

thank you! been lurking in your channel for a while now, great content sir!

King of SQL explanation

Thank you sir

THANK YOU. i have read a hundred tutorials and was stuck on the alias. starting with the from and on clauses and explaining the AS is implied and then going back to the select cracked things open for me. much appreciated.

and what if there is a period validity of the structure (include year and month column) ? should i put it on the same table ? is it okay to have duplicate rows of ppl name?

Great video. Is it possible to use self join and a many to many relationship simultaneously or it would work only for one to many? For example if an employee has 2 or more managers...

Thank you for the clear and simple explanation. I remembered seeing the Employee - Manager example somewhere a few years ago, but I couldn't recall where exactly I saw it.

Very clean, thank you

Man! That CATEGORIES example saved me just in time before creating many tables. Thanks

Thank you.

Great explanation just one doubt in the ER diagram for both examples of self join why did you show 1:many relationship?

Great content! Awesome channel!

Perfect explanation thanks a lot <3

Good tutorial

Great explanation!

got here from a course i couldnt understand this self join and Thanks to you it's all clear now. you explained it really well with the perfect examples. Keep up

Huge thanks for such a clear explanation! Helped a lot!

Thanks. It was 👍

Even after a year you are helping guys like me! Thanks for clearing my doubt

Thank you for this!

Thank you so much for this clear explanation

your explaining is great thank u..and good luck

This is how you should teach SQL.....step by step

Thanks for breaking this down so simply.

This is super helpful! Your voice is almost like listen to ASMR, lol. Nice to listen to

Definitely needed this and you explained it perfectly

What a video!!! Thanks :)

Nice & clear

somethething that i needed currently for my project. thanks a lot sir

I like how you talk :quiet and clear

thanks for the content !!

No wonder why you are calling yourself a database star 🔥🔥🔥🔥😁