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.
LinkedIn: www.linkedin.com/in/biplabparida
SQL JOINS : • SQL Joins With Example...
Join Multiple Tables: • Join Multiple Tables I...
Subscribe our Channel to keep watching interesting videos helpful for your career growth:
/ @codingglitz
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout different playlists:
PLSQL Tutorial : • PLSQL Tutorial || PL S...
Learn DBMS & SQL : • SQL Tutorial for Begin...
SQL Interview Questions and answers: • sql interview question...
Java Interview Questions and Answers : • JAVA Programs for inte...
IT Career guidance: • Career Guidance
Interview Tips : • Interview Tips
IT Essentials and Tricks : • IT Essentials and Tricks
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout Important videos :
Top 30 SQL Queries Interview Questions and Answers : • SQL Queries Interview ...
Top 50 SQL Concepts Interview Questions and Answers : • SQL Interview Question...
SQL JOINS : • SQL Joins With Example...
SUB QUERY : • Subquery in SQL || SQL...
Employee earning maximum salary in each department query : • SQL Query to find Empl...
How to delete duplicate rows from any table (2 different solutions): • SQL query to delete du...
How to find Nth highest salary (3 different solutions): • SQL query to find Nth ...
Tricky SQL Queries Part1 : • SQL Tricky and Importa...
Basics of Database : • What is DBMS? Learn B...
SQL OPERATORS : • Operators in SQL || S...
AGGREGATE FUNCTION: • Aggregate function ||...
GROUP BY : • GROUP BY & HAVING || ...
Solve any Date related query : • How to Solve any SQL Q...
How to use Substring : • Substrings in SQL | L...
How to practice SQL Queries in local / Install Database in local : • How to Install Oracle ...
IT Jobs without Coding : • IT Jobs without coding...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

[@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: www.linkedin.com/in/biplabparida

[@sakshichouhan7417]

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

[@veerachowdarykamani8615]

Wonderful content

[@CodingGlitz]

👍

[@ChitraPatil-l7j]

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

[@mandarganpule]

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

[@CodingGlitz]

👍

[@rajkasbe53]

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

[@CodingGlitz]

Thanks 🙏

[@ManormaPandey-q9s]

I always prefer this video, sir explained very well.

[@rameshchunchu686]

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

[@CodingGlitz]

🙂 Good to know.

[@saikumarsrimurthi1750]

It's total clear..... Nice explanation😊😊

[@namangarg7023]

Though I watched somany other explanation this one best

[@CodingGlitz]

Thanks 🙏

[@vikassinghjayara510]

Awesome video 😍

[@CodingGlitz]

Thanks 🙏

[@Hindavi_8500]

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

[@mohiuddinansari9356]

Well explained ! thanks

[@madhukadam5816]

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

[@CodingGlitz]

Ok sure

[@AbhishekKumar-xd3qq]

superb

[@CodingGlitz]

Thanks 🤗

[@Nalini08888]

Useful Video

[@mellowftw]

brilliant

[@CodingGlitz]

Thanks 😊

[@JamesBond-ge4mf]

Super 👍

[@NishantSinha-c4h]

Impressive video, thanks a lot

[@CodingGlitz]

Thanks 👍

[@KunalKumarSingh-wr1kg]

Excellent 👌👍

[@mudunuriprashanthi1428]

awesome. sir..clear explanation

[@CodingGlitz]

Thanks 😃

[@travelkare]

Dhnywad sahab 👏

[@CodingGlitz]

😊

[@MVinodKumar-tt1tu]

Very Nice Video sir

[@CodingGlitz]

Thanks 🙏

[@ashishkumarnaik4255]

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

[@ankitatarale7914]

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

[@CodingGlitz]

Sure...

[@mango-strawberry]

thanks

[@sushantamohapatra1124]

Nice

[@hemanthchanti1124]

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

[@dishabirje4679]

12?

[@abhinavkumar2662]

12 as per thumbnail

[@AnshikaSharma-yj4xw]

12.o/p : 10 10 10 10 10 10 20 30 40 NULL NULL NULL

[@anujsinghkushwah2712]

easiest explanation of very confusing concept.

[@ravi_pandey2815]

❤Bro thank you so much.

[@travelkare]

Queries used please in GitHub repository?

[@ShivamTiwari-hu6hg]

Thank you so much sir :)

[@travelwithmayur527]

Pls upload the multiple join table

[@CodingGlitz]

Sure will try by next week.

[@CodingGlitz]

Join Multiple Tables: ua-cam.com/video/eGdtpdow0rg/v-deo.html

[@raviyadav-dt1tb]

I think null never considered.

[@Raja-d6w]

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

[@meghajoshi860]

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

[@CodingGlitz]

No

[@ashisrout383]

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

[@CodingGlitz]

All the best for the future. Keep learning. 🙂

[@ashisrout383]

@@CodingGlitz Thank you very much ,you explained so well.

[@CodingGlitz]

Thanks 😊

[@kalyanideshbhratar8569]

Cross join me kitne record ayenge

[@CodingGlitz]

M * N

[@devashishghosh7497]

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

[@utsavsagar6665]

Bro you are going very fast not able to understand anything.

[@CodingGlitz]

Please go through this (ua-cam.com/video/isQ8up-zUPY/v-deo.html). complete join tutorial before watching this video

[@devashishghosh7497]

Null is just. Garbage value

[@priyankasaini7204]

thanks