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!

[@mastermind1299]

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

[@raovenkatesh2152]

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

[@wasimsaifi2039]

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

[@Evgeny-p8s]

a good explanation, thank you

[@chitrasrinivas7089]

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

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

[@davida99]

Best beginners explanation on self join. Thanks!

[@aboagyeampem6623]

Glad I saw this video. Thanks for sharing

[@bleuberrystains1186]

You, sir, are a hero.

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

[@sprihasingh6677]

Mazze aagyeee , Thank you Sir :)

[@crystalchaung1576]

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

[@sass520]

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

[@relaxationmusic7094]

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

[@ahsanabdulqader1553]

Great Job Sir

[@ranjithparuchuri6463]

nicely explained of joins

[@sapaliraj.forbes]

very good.simplicity level 100%

[@varunl6948]

Thanks for this!

[@parteekbhatia]

My pleasure!

[@akashgautam1909]

Thank you!

[@parteekbhatia]

You're welcome!

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

[@neelamkushwaha1703]

very nicely explained

[@parteekbhatia]

Thanks dear

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

[@monicakimeu1196]

thanks

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

[@sravanworld9419]

so nice....

[@parteekbhatia]

Thank you! Cheers!

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

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

[@FA-BCS-ALIRAZAUnknown]

wow

[@bradalza98]

liked and subscribed.

[@vlads7774]

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

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

Many many thanks