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

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

[@PocketSavvy-s7c]

​@@RishabhMishraOfficial bro ya file use kia hu wo dy du

[@kauraman6991]

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

[@atishalikhar6746]

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

[@RishabhMishraOfficial]

glad you liked it! :)

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

[@Aayatq]

This is wonderful. Thank you for your help.

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@dipannitadas6339]

Bohot ache se samjhaye sir. Thank you.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@labdhibavishi2430]

Thank you so much sir. best explanation ever.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@Desh-Videsh-Updates]

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

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@SirajuddinMohammed-zh8im]

Very nice but self join concept agar thoda aur descriptive rahta toh ache se samajh aaata

[@avneeshyashika_official]

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

[@rohitbhandare7376]

Great Work Thank you.!

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

[@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! ✅️

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

[@NismaKashif]

Thank You, Sir, for best explanation technique.

[@RishabhMishraOfficial]

Glad you liked ✅️

[@M_gaming992]

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

[@kumarishanupriya3733]

Thank you so much sir 🙏 for the good explanation

[@RishabhMishraOfficial]

Glad you liked ✅️

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

[@cybershrajal]

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

[@RishabhMishraOfficial]

Awesome, glad it was helpful ✅️

[@fit_tubes_365]

Thankyou So Much!

[@RishabhMishraOfficial]

Glad you liked

[@pooja1899]

Thank you for clear the confusion

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

[@rajikkhan8825]

Sir your explanation is very good . Thanks

[@RishabhMishraOfficial]

Glad you liked ✅️

[@ankitpurshottam3442]

good

[@RishabhMishraOfficial]

Thanks

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

[@vishu3040]

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

[@RishabhMishraOfficial]

Glad you liked it ✨️

[@kharedeeksha17]

very well explained

[@RishabhMishraOfficial]

Glad you liked ✅️

[@SubhamMajumdar-c9r]

hi sir first of all thank you for teaching in such easy way. sir i have a qu actually i didn't understand what is the difference between union and full join ? i think both returns kind of similar output then when we use union and when we use full join ?

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

[@dsa_tutorial]

Mindblowing keep going .

[@Sankiengineer]

Great

[@RishabhMishraOfficial]

Glad you liked ✅️

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

[@pareekshitraiyakwar4937]

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

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

[@Ishdeepkaur-e5o]

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

[@SandipanSarkar-c8v]

Finished watching

[@RishabhMishraOfficial]

Awesome, keep learning n keep growing 🚀

[@sandeepkumarnishad8009]

great explanation for ever

[@Digital_Ego]

Gr8 video

[@RishabhMishraOfficial]

Glad you liked it ✅️

[@SnehaKumari-e4l]

best🎉🎉

[@nabinbist1220]

Sir Normalization ke video vi banao like it

[@SandipanSarkar-c8v]

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

[@deepankarsaxena4636]

Select All ❌ Select Star ❌ Select Sab Kuch ✅

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

[@rizwan1396]

It means union all is same as full outer join?

[@neelamgaikwad9809]

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

[@archanarkumar9754]

Why T1 and T2 ? Table to ek hi hai

[@neilagarwal9698]

what is the difference between union clause and full outer clause

[@mukeshdhoni0786]

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

[@Ishdeepkaur-e5o]

I think ,ek hi table se hota h

[@abhinavsharma9178]

Shad Goswami vrinda ko jai

[@ShivamMishra-dh7zx]

Glad someone noticed

[@jiatxtmoa7434]

What is the difference between full outer join and union

[@moh.editzz]

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

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

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

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

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

[@shashanksingh5084]

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

[@ShivamMishra-dh7zx]

Glad someone noticed.

[@makarsh29]

bhai y union mysql m run nhi kr rha

[@DeadlyGaming407]

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

[@RishabhMishraOfficial]

Then it's not a duplicate

[@Altaf_Alam]

❤

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

[@galgotianhelper610]

😊

[@syedarshad9028]

Select sab kuch😂

[@Digital_Ego]

Python ???

[@Amannarwal280]

Sir synatx error show kar raha hu = I'd

[@RishabhMishraOfficial]

Check spelling of column names

[@Bloging-yadav]

Ye work Nahi kr raha hai