Self Join and Its Demonstration

[@jaypandey007]

Just what I was looking for.
The visual slides made it absolutely clear for anyone to understand and remember Self-Join forever.

[@parteekbhatia]

Thanks dear
Please share the information of this channel with your friends

[@ali.8980]

Thnx for your illustration, this is what I am looking for, the demonstration is so helpful

[@swarnimjambhule3264]

THANK YOU, it's a must to know the basics before jumping in the higher query rather than trying to solve an advanced query and wonder what's going on.

[@alexandersfetcu1121]

Thank you, the first few seconds was all I needed to understand self joining. Thank you!

[@relaxationmusic7094]

Thank you so much. You put together such a nice content that's easy to understand. Exactly what I was looking for :)

[@davida99]

Best beginners explanation on self join. Thanks!

[@raovenkatesh2152]

Finally I got it .. U r great explanation sir..

[@bleuberrystains1186]

You, sir, are a hero.

[@chitrasrinivas7089]

Excellent explanation sir..lot and lots thanx to u👌👌👌👍👍

[@md.farzan5596]

I was getting wrong output in inner join. But after watching the slide I got the actual point which was causing the error.
Great Sir 😄

[@mastermind1299]

saw multiple videos but didnt get.this explanation really help me.

[@aboagyeampem6623]

Glad I saw this video. Thanks for sharing

[@sapaliraj.forbes]

very good.simplicity level 100%

[@sprihasingh6677]

Mazze aagyeee , Thank you Sir :)

[@rajvaibhavtawadkar164]

It's very helpful sir grate job🤗🙇‍♂️❤🙇‍♂️

[@parteekbhatia]

Thanks dear.
Please share information of this channel with your friends and contribute in the moment of spreading the knowledge. Your efforts in this direction matter alot to me. Thanks.

[@osoriodanny]

You saved my life and my homework! Thank you

[@parteekbhatia]

Please share this channel with your friends

[@parteekbhatia]

Thanks dear.
Please share information of this channel with your friends and contribute in the moment of spreading the knowledge. Your efforts in this direction matter alot to me. Thanks.

[@bradalza98]

You deserve more subscribers, thanks a lot.

[@parteekbhatia]

Dear
Going start live PL/SQL sessions from 18th April at 6 PM to cover full PL/SQL in one month. Two live sessions per week. Wednesday and Saturday. Please join and share the information with your friends.

[@ahsanabdulqader1553]

Great Job Sir

[@ranjithparuchuri6463]

nicely explained of joins

[@varunl6948]

Thanks for this!

[@parteekbhatia]

My pleasure!

[@ramanavenkat4588]

we got more clarity on self join sir. nice

[@parteekbhatia]

Thanks dear.
Please share information of this channel with your friends and contribute in the moment of spreading the knowledge. Your efforts in this direction matter alot to me. Thanks.

[@bradalza98]

liked and subscribed.

[@Entertainingzone2023]

Perfectly explained sir .. Best vedio on self join . Thanks sir

[@parteekbhatia]

Please share information about this channel with your friends

[@parteekbhatia]

U r from which institute

[@Entertainingzone2023]

@@parteekbhatia yes sure

[@sass520]

sir @ 4:30 do we use "+" when we show left join with self?

[@crystalchaung1576]

When were e and m for e.ename and m.,ename assigned? Why is there a comma on m.,ename?

[@akashgautam1909]

Thank you!

[@parteekbhatia]

You're welcome!

[@wasimsaifi2039]

Sir kese aapne samjha h
Example ke through it's awsome

[@FA-BCS-ALIRAZAUnknown]

wow

[@neelamkushwaha1703]

very nicely explained

[@parteekbhatia]

Thanks dear

[@monicakimeu1196]

thanks

[@sravanworld9419]

so nice....

[@parteekbhatia]

Many many thanks

[@vlads7774]

should have chosed different names, they are all very similar which makes it hard to understand

[@methrivandana9021]

I have to create two tables with same name sir

[@parteekbhatia]

Dear
Going start live PL/SQL sessions from 18th April at 6 PM to cover full PL/SQL in one month. Two live sessions per week. Wednesday and Saturday. Please join and share the information with your friends.

[@sammanluitel3018]

Not clear why have u done e.mgr_name =m.emp_name why not reverse pls explain

[@parteekbhatia]

Reverse can also work. Conceptually no difference

[@sammanluitel3018]

By reverse I mean to say e.e_name =m.mgr_name

[@bradalza98]

@@sammanluitel3018 because we want to join first table managers id to the second table of emp id, first table manager id contains entire information of that row or tuple and same second table emp id contain entire information of that row and when we join these conditions we will find the managers of that employees.

[@sravanworld9419]

so nice....

[@parteekbhatia]

Thank you! Cheers!