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

SQL Full Course Playlist 👇

Like, Share & Subscribe Now :)

➖➖➖➖➖➖➖➖➖➖➖➖➖
Timestamps:
00:00 Intro
00:06 Self Join
01:17 Self Join Example
02:43 Self Join in SQL
05:22 UNION
06:17 UNION ALL
07:06 UNION & UNION ALL Example

➖➖➖➖➖➖➖➖➖➖➖➖➖
Target keywords: sql self join, self joins in sql, self join with example, union in sql, union all in sql, sql joins, sql joins with examples

➖➖➖➖➖➖➖➖➖➖➖➖➖
Related Videos
Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1

Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2

Create Table In SQL & Create Database | SQL Tutorial In Hindi 3

INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4

SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 5

How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 6

String Functions in SQL | Functions in SQL | SQL Tutorial in Hindi 7

Aggregate Functions in SQL - COUNT, SUM, AVG, MAX, MIN | SQL Tutorial in Hindi 8

Group By and Having Clause in SQL | SQL Tutorial in Hindi 9

TimeStamp and Extract Function | Date Time Function | SQL Tutorial in Hindi 10

Complete SQL JOINS For Beginners | SQL JOIN Queries with Examples | SQL Tutorial in Hindi 11

Useful videos
How to Become Data Analyst in 2022 | Data Analyst Roadmap

Data Analyst skills, jobs and Roadmap

Excel Tutorial for Beginners

➖➖➖➖➖➖➖➖➖➖➖➖➖
Connect on other Social Media handles:

➖➖➖➖➖➖➖➖➖➖➖➖➖

If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
Have a great day buddy!

[AshishTiwari-uglg]

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.

[kauraman]

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

[Desh-Videsh-Updates]

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

[warriorspartan]

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.

[GauravSharma-xpgf]

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

[kiddosknowledgewizbyakshit]

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)

[neelamgaikwad]

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

[RishiRap]

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

[M_gaming]

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

[labdhibavishi]

Thank you so much sir. best explanation ever.

[Aayatq]

This is wonderful. Thank you for your help.

[dipannitadas]

Bohot ache se samjhaye sir. Thank you.

[avneeshyashika_official]

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

[urbanpahadihiker]

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)

[kumarishanupriya]

Thank you so much sir 🙏 for the good explanation

[atishalikhar]

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

[NismaKashif]

Thank You, Sir, for best explanation technique.

[Bhartiya]

we can use intersect only for duplicates values
select * from table_1
intersect
select * from table_2

[SandipanSarkar-cv]

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

[mohammadsaddam]

Thank you, u helped me in my bca exams ❤