SQL SELF JOIN | UNION & UNION ALL in SQL | SQL Tutorial in Hindi 12

[@kauraman6991]

I always struggled to understand joins . Thanks for explaining in such a great way 🙂

[@NismaKashif]

Thank You, Sir, for best explanation technique.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@AshishTiwari-ug2lg]

I was looking for a Hindi guy who can teach the SQL in very normal way. finally i found you Brother. the way of you teaching is simply awesome and Thanks for the video Man.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@kumarishanupriya3733]

Thank you so much sir 🙏 for the good explanation

[@RishabhMishraOfficial]

Glad you liked ✅️

[@kiddosknowledgewizbyakshit9954]

Really in a simple language you have explained these important topics... Thanks a lot( Although I have researched many tutorials but couldn't find this kind of crystal clear explanation)

[@warriorspartan1697]

I have been trying to understand self join for quite a long time, but your illustration @04:05 leaves no doubt anymore. Thank you very much Sir.

[@RishabhMishraOfficial]

Glad it was helpful! ✅️

[@GauravSharma-xp5gf]

Sir you give the best explanations, keep doing this. I had searched a lot for this kind of videos 👍

[@RishabhMishraOfficial]

Glad you liked it 👍

[@urbanpahadihiker8672]

Dear sir , Why we are taking , what is the reason behind ???? (On T2.empid = T1.manager_id ) Instead of (On T1.empid = T2. Manager_id)

[@ReelgramJams-vm3ug]

thats the same problem i have, nobody tells u about this

[@ReelgramJams-vm3ug]

if apko reason pta chla ho toh pls btana

[@dipannitadas6339]

Yes we can use T1. Empid = T2. ManagerID. Then in select part we need to put 'select T1. Empname As Manager Name , T2. Empname As Employee Name.... '

[@iamsatyamjha]

In the given SQL query for a self-join, you have chosen to join the EMP table with itself using the condition ON T2.EMPID = T1.MANAGERID. This means you are joining the table on the employee's ID (EMPID) matching with the manager's ID (MANAGERID). The reason for this choice is to establish a hierarchical relationship between employees and their managers. By using T2.EMPID = T1.MANAGERID, you are retrieving rows where the EMPID of one record (representing an employee) matches the MANAGERID of another record (representing the manager). This way, you can identify the managers of each employee. If you were to use ON T1.EMPID = T2.MANAGERID, it would imply a reverse relationship where you are trying to match employee IDs with the manager's ID. This might not provide the desired hierarchical structure, as it would indicate employees who manage other employees. In most organizational structures, employees report to managers, so it makes more sense to use T2.EMPID = T1.MANAGERID for a self-join in this context. In summary, the choice of ON T2.EMPID = T1.MANAGERID is appropriate for representing the relationship between employees and their respective managers.

[@Aayatq]

This is wonderful. Thank you for your help.

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@atishalikhar6746]

Even gate smasher can't made me understand this smooth that you done

[@RishabhMishraOfficial]

glad you liked it! :)

[@labdhibavishi2430]

Thank you so much sir. best explanation ever.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@padhaidotcom9276]

could you please sir, repeat this class once more i am very confused to this class, i didn't understood difference

[@RishabhMishraOfficial]

Okayy noted ✅️

[@avneeshyashika_official]

Heyy riahabh jo apne union krwaya mai actually oracle m krti hu to mujhe 2no ka hi same op mila

[@pooja1899]

Thank you for clear the confusion

[@vishaluniverse66]

jioooo. Kya example diye ho, sb clear ho gya..❣

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@M_gaming992]

aren sir g love you ho geya kiya hi badiya smja diya apna tu

[@rohitbhandare7376]

Great Work Thank you.!

[@dipannitadas6339]

Bohot ache se samjhaye sir. Thank you.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@vishu3040]

Thank you sir Thanks a lot You explain in better way 🤩😍😘😘

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@Khan-mc3gi]

sir great video and easy to explain by you sir how to apply sql project in power bi for example if i find who customer most purchase made so sir how i visualize this in power bi visualization to show who customer make most of purchase by company there is any video u make pls share if u make

[@rajikkhan8825]

Sir your explanation is very good . Thanks

[@RishabhMishraOfficial]

Glad you liked ✅️

[@cybershrajal]

randomly scroll kar raha the achanak se aapki video aa gayi. paper acha gaya

[@RishabhMishraOfficial]

Awesome, glad it was helpful ✅️

[@RishiRap]

self join totally incomprehensible. You need to elborate MORE on Self join.

[@radhikateli]

Rest everything i understood except self join...lil bit confusing.. Rishab sir your teaching is awesome. Please explain the concept of self join in detail

[@kharedeeksha17]

very well explained

[@RishabhMishraOfficial]

Glad you liked ✅️

[@mahendraprajapati9809]

Very nice Rishabh, very simple way, thank you very much for this. Can you please make more advance videos on MS ACCESS DATABASE VBA

[@RishabhMishraOfficial]

Okayy noted

[@avanendrasharma8244]

On question sir In Self join after on could it not be written like t2.emp_id=t1.manager_id or t1.emp_id = t2.msnsger_id

[@ankitpurshottam3442]

good

[@RishabhMishraOfficial]

Thanks

[@sunilsaini6299]

3:25, Agar Join likte h to Self Join consider hota h bymistake u said Inner Join

[@arjunbhasin8302]

INNER hota hai

[@sonuamlani8516]

Hi Rishabh, @ 03:23, you mentioned when we write just JOIN it is considered as INNER JOIN. I think you mean to say SELF join correct ?

[@RishuPuri]

nope, he said if we simply write JOIN it will considered as inner join, we have to write the same table_name again as t2 for self join...

[@RishabhMishraOfficial]

@RishuPuri yes that's correct!

[@Sankiengineer]

Great

[@RishabhMishraOfficial]

Glad you liked ✅️

[@pareekshitraiyakwar4937]

Respected sir, can you PLEASE make a video on the topic of... EQUI & NONEQUI JOIN

[@dsa_tutorial]

Mindblowing keep going .

[@user-vp1yk6dj9p]

sir ,agr 3,4 table diye ho toh sbko join krna jruri hai yaa use case k hisaab se join krna hota h?

[@user-lm5wb8vi1x]

This dataset is not present ,Kindly update this file for practice which is valuable otherwise we have to manually create it.I hope u can understand

[@IMRANANSARI-yo1mm]

Sir, what's the difference between inner join and union join as i feel it is similar. Further more, for union join all the headers of both the table should be similar?

[@rivughosh4814]

Isn't union uses two tables and inner join is with in same table?

[@sandeepkumarnishad8009]

great explanation for ever

[@neelamgaikwad9809]

Hi rishab yeh 4:08 timestamp pe T2 kyu pehle lia hai... Why not T1.empid = T2 manager_id??

[@nabinbist1220]

Sir Normalization ke video vi banao like it

[@neilagarwal9698]

what is the difference between union clause and full outer clause

[@SnehaKumari-e4l]

best🎉🎉

[@shashanksingh5084]

are you Vaishnava?? because you are taking the name of prominent 6 Goswami of vrindavan?

[@ShivamMishra-dh7zx]

Glad someone noticed.

[@Digital_Ego]

Gr8 video

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@jiatxtmoa7434]

What is the difference between full outer join and union

[@rizwan1396]

It means union all is same as full outer join?

[@user-lm5wb8vi1x]

Finished watching

[@RishabhMishraOfficial]

Awesome, keep learning n keep growing 🚀

[@deepankarsaxena4636]

Select All ❌ Select Star ❌ Select Sab Kuch ✅

[@gate2ece357]

Bhaiya, mai UNION likha toh b 5 rows a raha hai .. aisa kyun zara bataiyega. Madan Mohan ka 2 bar nama a raha hai .

[@RishabhMishraOfficial]

Agar sari values same hogi tabhi vo duplicate hoga. You can try only select Name column to check of there are still duplicate values or not.

[@imanjabbar5433]

what if dont use aliases why it is not working without using aliases

[@RishabhMishraOfficial]

It should work, check the syntax n table n column names

[@Cricstory0108]

Self join run nahi ho raha ha

[@moh.editzz]

hello sir ,in my workbanch do not work "full outer join" sir plzz solved lots of problem.🙏🙏🙏

[@mahendrapandit8606]

Hii sir good morning your video is very well explaind sir data science regarding aapse bat karni h please tell me aapse contact kaise kru thank you

[@abhinavsharma9178]

Shad Goswami vrinda ko jai

[@ShivamMishra-dh7zx]

Glad someone noticed

[@makarsh29]

bhai y union mysql m run nhi kr rha

[@g.sproduction1674]

Sql me kisi bhi file ko import kaise karte hai iske liye video bna dijiye

[@RishabhMishraOfficial]

already uploaded, watch video- create table in sql

[@DeadlyGaming407]

what if name is same but amount is differnt and we did union ??

[@RishabhMishraOfficial]

Then it's not a duplicate

[@mukeshdhoni0786]

Sit table 2 banta hai naa isme ya ekhi table se ho jayega

[@user-vp1yk6dj9p]

I think ,ek hi table se hota h

[@Altaf_Alam]

❤

[@archanarkumar9754]

Why T1 and T2 ? Table to ek hi hai

[@Batistabrockbombf5]

Union karte tim madan mohan to nahi aana chaiye tha. ye name to dono table me hai to union sirf unique values leta ha. can anyone explain???

[@wasilkhan2507]

union takes all the values from both the tables and show only unique values in output.

[@syedarshad9028]

Select sab kuch😂

[@Bloging-yadav]

Ye work Nahi kr raha hai

[@galgotianhelper610]

😊

[@Digital_Ego]

Python ???