Most Frequently asked SQL JOINS Interview Question | What does different SQL JOINS return

In this video we have discussed the most frequently asked SQL Interview question where we have to find the output or the total number of Rows with 2 given tables. We have discussed this example with different types of data and for INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN and SELF JOIN.

SELF JOIN example covers the scenario of multiple matching records between 2 tables. This example can help you clear SQL JOINS concept and should be prepared before going for any interview.

Please like & share the video.

Subscribe our Channel to keep watching interesting videos helpful for your career growth:

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout different playlists:

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

Checkout Important videos :

--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

[CodingGlitz]

Thanks for watching. If you want to connect on LinkedIn and stay updated with my professional updates and network with me, here's my LinkedIn profile:

LinkedIn:

[sakshichouhan]

Best explanation of joins. This was the most challenging topic for me, the way you explained, cleared all my queries. Thankyou.

[ChitraPatil-lj]

Awesome sir... thank you so much sir...now my concepts are clear...its so easy....Thanks again

[ManormaPandey-qs]

I always prefer this video, sir explained very well.

[rajkasbe]

the way you I'm big fan of you
thank you so much for everything u r doing

[mandarganpule]

👏 You explained this complex sql problem with nice example and in very simple language 👍

[Hindavi_]

this is awesome i face this q and i m wrong bt now i m very clear thank u so muchb😊

[rameshchunchu]

It is Awesome. The way you explained is awesome and very clear and understood the joins more clear

[namangarg]

Though I watched somany other explanation this one best

[madhukadam]

Sir it's really very helpfull, but please you have to define one join, is Cartesian join

[ashishkumarnaik]

when you are doing left using null, why do 2 null records are not coming? timestamp 9:24

[hemanthchanti]

How many records, we will get as output for full outer join ? Please some one answer....as per thumbnail query

[ankitatarale]

Sir please make a video on equi, non-equi, natural and self join also...

[travelkare]

Queries used please in GitHub repository?

[anujsinghkushwah]

easiest explanation of very confusing concept.

[meghajoshi]

Sir if there is 0 instead of null.. will get the same output?

[Raja-dw]

Thumbnail query answers-
Inner join -6
Left and right - 9
Full - 12

[devashishghosh]

Null is just a garbage value one null is not equal to another null

[ashisrout]

Same question i faced.unfortunately I could not answer.😿