Most Asked SQL JOIN based Interview Question | # of Records after 4 types of JOINs

In this video we will discuss SQL Join based interview question where you need to tell no of records in output when you join 2 tables. This question is very important from interview point of view as well join understanding point of view. It is a must watch concept.

[@ankitbansal6]

Master the art of SQL with my zero to hero SQL course. The course is focused on data analytics and covers all the advanced concepts starting from scratch.
www.namastesql.com/course-detail/think-sql-go-from-zero-to-hero-english
The course contains 2 portfolio projects and a bonus session on Tableau.
50+ interview problems to crack any SQL INTERVIEW.

[@PradyutJoshi]

No one would have explained this concept better. Please keep making more such videos 🙌

[@ankitbansal6]

Thank you for your kind words :)

[@Saumyagrow]

Before watching ur video I feel I know all in Joins but after seeing I m missing the gem thanks man for clearing topic

[@sandeepreddy7687]

I have lot of confusion to answer these kind of questions during interviews, but now I'm crystal clear with these kind of questions and can answer anything from Joins. Thanks sir!! Much appreciated for sharing your knowledge with us.

[@aakriti_100]

Sir, I surfed internet for these scenario based questions on joins for long & finally got your video. Can't thank you much! This really helped me :)

[@luckyagrawal6029]

I faced this question in EXL services interview round and couldn't answer it correctly. Thank you Ankit for the wonderful explanation

[@ritikajaiswal3824]

I have watched multiple videos for this topic. I even clicked this video thinking what extra thing he can teach me. Now you blow my mind. Very well explained. Now I'm going to binge watch your videos

[@ankitbansal6]

Good to know that 😊

[@thepositionalplay5307]

You deserve a lot more recognition man. Keep going on, I'm sure you'll blow up one day. Awesome content btw

[@ankitbansal6]

Thank you so much 🙏

[@anjalishar1829]

True!

[@NITIANShubham]

Awesome bro

[@jinkazama6156]

Yaa even , i usually go for practicing SQL in geeksforgeeks but some of my frnds suggest me to this yt channel, this is how ur popularity increasing,
And ofcourse I will also suggest others for this😌

[@anushkagoyal1640]

How are blank values handled in the case of different joins ?

[@apurvasrivastava6394]

you made the topic crystal clear with these examples. keep coming up with more such videos.

[@shivanis6969]

Similar questions was asked to me in an interview.. even when I was aware about the concept of joins I wasn’t able to answer in a clarifying and convincing manner.. now I gained the confidence to approach the question… thanks for the video with awesome elaboration and explanation..

[@ankitbansal6]

Excellent!

[@saketsourav_hjp]

Exactly even I took this joins lightly but stucked on this in the interview

[@surajd2338]

Post clearing interview, i got to see this question here. Anyways thanks for more clarity. I cleared this question with own logic and got it all clear for all joins. 😀

[@ankitbansal6]

Awesome

[@ankurranjan3218]

These are really most asked questions in any top product based company for Data Engineering role. Keep up the good work Ankit. I really appreciate your effort. Well explained too.

[@ankitbansal6]

Thank you Ankur 🙂

[@sandeepreddy7687]

I faced this question in broadridge company interview yesterday unable to answer and now I can answer these type of question anytime. Thanks Ankit.

[@ankitbansal6]

Good to know 😊

[@suhassajjan4056]

omgaad,this type of questions have hit me hard many times in my interview,thanks for the explaination

[@MamtaKumari-qu9jr]

Has been searching for these kind of videos after so many rejection in interviews for the similar kind of scenarios, and finally a great stop here!!!! Thank you so much for the help😊

[@ankitbansal6]

Good to know 😊

[@koushikdey100]

This is awesome. Last Thursday I was asked this question by the interviewer from an renowned organization.

[@davidlaid-ur9xn]

Liar

[@uttamx2016]

good exercise to learn join output , which I used to confuse in past 9 years .Now I am confident .
Thank you so much

[@ankitbansal6]

Glad to hear that!!

[@ramyasrielluri3243]

Your explanation is very well very clear if any one ask me in sleep also i will tell
.now it is very clear i have 2.5 years of experience but didnt get this much of clarity till now. .now its clear .thanks alot🎉

[@sushmamc8904]

Just now I got this question in my interview ... concepts got cleared.. thank you

[@MukarramJahmj]

Thank you so much man.! Have been struggling from months to understand this and you cleared it out in 14 mins. Thank you again.!

[@ankitbansal6]

Glad to know that 😊

[@deepshikhamishra9216]

Many times I got stuck with null values as I used to see these null in the output, Aaj jake clear hua hai ye, Thanks a ton 🙏

[@MG-hc4rr]

Been there facing similar scenarios in interviews..Really an awesome video😍✨great learning for me..💪thanks for clearing these concepts so well 🙌 really helpful 🌟

[@ankitbansal6]

This is great 🙏🙏

[@AlbouryNdiaye-ro8qz]

This tutorial is an excellent resource among the many explanations (videos, books, articles) I have seen on this topic. It is the most helpful. Thank you very much, Ankit

[@ankitbansal6]

Glad it was helpful! Keep watching 😊

[@bandhammanikanta]

NULL != NULL. Thanks for sharing. The explanation was very good that I could consume all you explained.

[@hallowedshubh5073]

Wanting to switch my career and get into Data Engineering. Visited your channel from LinkedIn. This is top rated content from which I would love to gain knowledge. Thanks a lot

[@ankitbansal6]

Welcome to the channel 😊

[@saberabegum9463]

Are you in data analyst side ?

[@deepthimurali962]

Going through interviews currently and faced similar questions! Thank you ankit ✅

[@ankitbansal6]

That's great 😊

[@sahilkushwaha7490]

Encountered very similar questions in my interview. I cracked interview for Data analyst role in big firm, Thank you for explaining clearly. Kudos to you

[@ankitbansal6]

Excellent!

[@sonip472]

Omg, finally all my confusion around such questions has resolved, thanks a lot 👍 you are awesome 🙂

[@inderpanda1]

This is the best explanation video I have seen till now on JOINS 👍👍

[@ankitbansal6]

Awesome, thank you!

[@spark9_]

Excellent explanation, and very relevant. Got a similar question (also included cross join) for a data engineer interview

[@avi8016]

I was asked this question in interview yesterday, thanks to your video i was able to solve it.
Thankyou 🙏

[@ankitbansal6]

Most welcome 😊

[@esr58]

Very thankful🙏 sir.... Before this I counting one by one but now multiple of matching record is easy😎 thank you🙏

[@darpexplained79]

Thank you so much sir for explaining this concept i failed an interview earlier due to this question but now I am aware of the correct methodology

[@ankitbansal6]

You are most welcome

[@abhishekagrawal5237]

Thank you for explaining in a such a simple manner. Big thanks and cheers Sir, going to binge watch the entire SQL series. :)

[@ankitbansal6]

Thank you 😊

[@shubhamjaiswal3799]

Really a very helpful video this was asked to me in Barclays interview.
Thank you for posting this video.

[@Kanchan-m5c]

Thank you so much for such a crystal clear explanation. Lost an opportunity because of this. Will prepare using your playlist and update once I land a job.🎉

[@ankitbansal6]

All the best 💪

[@sudan9393]

thanks for covering all possible cases, this was missing from other videos about this question. This was very useful!!

[@pratiksingh9480]

This is really helpful to those going for SQL interviews.

[@ankitbansal6]

Thank you 😊

[@vrishabhbhonde6899]

Thanks for the video ❤❤. I have been asked this question in one of my interview and unfortunately I got bit confused as I was unaware of this video that time.

[@kavitapawar2524]

very helpful. I am for this video, thank you for sharing.

[@anshulgupta1611]

wow.. how you made this simple...thanks. even 10 year student can learn from this method now, simple and clear.

[@ankitbansal6]

Thank you 😊

[@0SIGMA]

This was asked in my TCS interview for data analyst. I answered wrong but I was soo confident on my answer that they liked it and I ended with offer letter. Although I rejected it for a better one )

[@bhupendrasharma386]

Interview had asked this question from me, few hour ago for etl developer profile, thanks for explaining

[@aanavourjoy]

Really a great explanation of these questions.. hatss off brother.thanks..

[@ankitbansal6]

My pleasure

[@mohanbabu3030]

One of the best video on joins i have seen till now, great explanation,👏

[@Urmilavijay20]

This Question was asked in Lenskart Interview and I couldn't answer. Thanks for the inputs

[@vivekkumarsingh9009]

I regret not coming across this video before. Great work. Thank you

[@ankitbansal6]

Better late than never 😊

[@razx2009]

in JOINS sql takes each records from 1st table with whatever condition mentioned in ON clause and keeps checking every records in 2nd table till the end.
so suppose i have 3 rows in 1st table and 10 rows in 2nd table then it will check 30 times 3x10. thats how joins work whether you use INNER, LEFT, RIGHT, OUTER, SELF

[@dollysingh9364]

I was looking for this solution from so long . Finally I got the solution

[@shashankchandramouli34]

Thanks a lot. The exact same questions were asked to me in an interview. Thanks to you I was able to answer this. Your explanation is so simple that even someone who does not know sql can understand . Please keep doing more videos like this .

[@ankitbansal6]

Glad it was helpful!

[@sunitasahu307]

Great Explanation covering all scenarios, it's really helpful

[@bhumikasoni361]

Awesome video, It gives good clarity with easy explanation

[@ramathasramalingam6659]

Very Clear explanation..Thanks, Sir

[@ankitbansal6]

You are welcome

[@venkateshwaranp5130]

Thanks for clear and easy to understand the concepts of Joins Quickly

[@sudhanshubhardwaj9325]

You’re are awesome at explaining complex concepts bhaiya❤
Thanks a lot for sharing such sessions

[@Slantz00]

This is a great video that answered a question I was asked during an interview.
I appreciate your sharing this video

[@mohammadmahaboobjani4280]

Thank you for explaining joins in detail and simple manner for different scenarios. Its a great learning for me. really helpful.👍

[@ankitbansal6]

Glad it was helpful!

[@PratikPictures]

Thank you so much for your simplicity in teaching..It really helps in boosting our confidence while learning something new

[@NaveenKumar-fq4sb]

Super trick sir ....even my trainer didn't told like u..

[@ankitbansal6]

Keep it up

[@cheequsharma7391]

Very good example and explanation. 👍

[@ankitbansal6]

Glad it helped!

[@nikhilchoudhary7860]

Finally this concept is clear because of you Brother🤗. Thank you Brother 🤝

[@ankitbansal6]

Glad to hear that

[@yateshpatil866]

Amazingly explained…Ty so much👍🏻

[@ankitbansal6]

My pleasure 😊

[@mohammeddanish8624]

I found the way and the technique much effective as well as easier. Thanks a lot!

[@ankitbansal6]

You're welcome!

[@yogitashinde2036]

Thank You So Much For This Concept😊.

[@RajChoudhary-jm9io]

Thanks Ankit, today this question was asked in my interview. Thank god I'm following your channel. More power to you!!

[@yashitarelwani4404]

Thank you Ankit Sir. Such an amazing video. Really helpful and got all my confusions gone.

[@ankitbansal6]

Glad to hear that

[@shubh0707]

yesterday i was asked same question. i made few mistake .but now i feel well prepared ..thnks :)

[@DeepshikhaMeena-g2i]

Very well explained

[@harish1838]

Came here after seeing your recent linkedin post completely enjoying it

[@ravivarma8988]

This is the best free software Ive seen. Respect.

[@ankitbansal6]

Thank you 😊

[@varunmonga8932]

Hi Ankit sir, can you please make one video on joins in which 1)after joins there is a where condition also with multiple conditions with "and" and "or"
2)after joins filtering with where clause and "and" clause

[@nagendras9696]

Great explanation Sir 🥳🥳🥳

[@shakthimaan007]

This is awesome

[@RAJANKUMAR-tl9xc]

Thank you so much bro... This is probably the best explanation I could find till now 😍❤️

[@semikolon4229]

This video is pure GOLD.

[@joeljx007]

This was asked in my interview and I made mistakes. For sure, next time I get asked this question, I won't be making a mistake. Thanks Ankit :)

[@ankitbansal6]

Excellent!

[@hijamgyaneswarsingh879]

Thankful for this video to regain my concept much more clear. Please do upload much more videos.Your explaination is crystal clear...

[@satheshkumar8120]

i am searching this from last years now i got the solutions

[@ankitbansal6]

Awesome

[@divyasworld9862]

first time i understood why full joins retiurns nulls...thanks Man :)

[@ankitbansal6]

Awesome 👏

[@Ak12345-g]

I have fair understanding of joins by this ankit❤

[@madhumms]

Most helpful with these scenarios. Thanks a lot

[@devarajanmurugesan3142]

Oh man. You are awesome. You have explained the joins with simple multiplication and addition concept. It gives good confidence to work with join. I can't forget this concept. Appreciate your work and time

[@ankitbansal6]

Great to hear!

[@hpaolani]

I like the concept you use for explaining and illustrating SQL questions . Awesome job man !

[@ankitbansal6]

Thank you 😊

[@adi_sekar]

Excellent video, thank you!

[@ankitbansal6]

You are welcome!

[@mayankdipesh9705]

watching this after going 0 in interview ! thanks Ankit for posting

[@ankitbansal6]

Enjoy

[@abhi1994100]

great video, finally found a video on this question and concept

[@nishantverma2966]

Thanks for this video I had some confusion in it and you have explained everything 🙏🙏

[@ankitbansal6]

Glad to hear that

[@pratibhamishra869]

Absolutely perfect video on this topic.

[@ankitbansal6]

Thank you 😊

[@mallikarjunpatil7553]

Great explanation
Can answer any type of join scenarios

[@ankitbansal6]

Awesome

[@vinayakacn401]

nice video, very informative and precise, thanks keep up the work

[@sudheerkumar-tp1mg]

Recently I came across one interview and failed but given very good clarification

[@priyankathakare2760]

Very well explained.thanks

[@ankitbansal6]

You are welcome

[@NitinMohanSharmanms]

Thank you sir...i am really thankful and appreciate your efforts..keep up the spirit

[@tusharhatwar]

Great explanation Sir 👍
Thanks a lot

[@ankitbansal6]

Most welcome

[@vikramr9437]

Excellent video sir, I got same question in interview.

[@SONU1476]

Thank you Cleared the doubts ..
Wonderful Man 😊

[@cajonnoob]

I have been in this scenario, thanks for explaining in detail

[@pranaykukadkar7092]

The real content of SQL

[@ManaTelugodey]

Great explanation..Thanks

[@nishas3527]

Such a simple and great explanation! Thank you !!

[@ankitbansal6]

Glad you liked it!!