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.

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

[@PradyutJoshi]

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

[@ankitbansal6]

Thank you for your kind words :)

[@kishanraj4645]

I was asked this same question during my interview, and I was initially confused about it. This video clarified the concept perfectly for me!

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

[@asparshraj9016]

Same concept was asked in an interview, nailed it 🔥🔥

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

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

[@luckyagrawal6029]

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

[@suhassajjan4056]

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

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

[@apurvasrivastava6394]

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

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

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

[@ArtsbyVaishh]

Thank you for the very clear explanation.. Now I am confident that I won't make any mistake in these type of question.
Keep creating such videos
With simple and easy examples.
It was easy to understand and very helpful 😊🙏

[@koushikdey100]

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

[@davidlaid-ur9xn]

Liar

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

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

[@sushmamc8904]

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

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

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

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

[@inderpanda1]

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

[@ankitbansal6]

Awesome, thank you!

[@deepankan03]

Its very interesting and well explained. Thanks for helping us out.

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

[@prakharadgale6463]

Everything regarding joins is cleared through this video. Thanks!

[@mohanbabu3030]

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

[@shalinikumari-lq8zt]

Thank you Ankit for this wonderful video.🎉

[@akshaykodekal8483]

Very clearly explained all concepts about joins

[@Slantz00]

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

[@kavitapawar2524]

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

[@mounikasai8960]

Crystal clear explanation..very much impressed.Thank you so much..,

[@bandhammanikanta]

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

[@Manoharc-n9h]

Clear & best explanation.

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

[@abhinavtiwari4238]

Simple thing to assume about null is not all nulls are same

[@shubhamjaiswal3799]

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

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

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

[@spark9_]

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

[@soniaas9864]

Thank you for more usefull content.

[@sonip472]

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

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

[@Villagegirl_in_IT]

Really helpful🙌

[@vatsalasharma6131]

Very well explained.

[@jyotianand5007]

Very well described and explained, thankyou

[@pratiksingh9480]

This is really helpful to those going for SQL interviews.

[@ankitbansal6]

Thank you 😊

[@avi8016]

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

[@ankitbansal6]

Most welcome 😊

[@vivekkumarsingh9009]

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

[@ankitbansal6]

Better late than never 😊

[@harish1838]

Came here after seeing your recent linkedin post completely enjoying it

[@venkateshwaranp5130]

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

[@bhupendrasharma386]

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

[@nandkishoresrivastava2074]

Thanks for sharing the informative video.

[@ankitbansal6]

Glad it was helpful!

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

[@dollysingh9364]

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

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

[@anshulgupta1611]

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

[@ankitbansal6]

Thank you 😊

[@sudan9393]

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

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

[@bhumikasoni361]

Awesome video, It gives good clarity with easy explanation

[@shivarajhj9484]

Good one, thanks for sharing this

[@ankitbansal6]

🙏

[@esr58]

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

[@divyasworld9862]

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

[@ankitbansal6]

Awesome 👏

[@Absvenkatm]

Nice information and explanation

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

[@sunitasahu307]

Great Explanation covering all scenarios, it's really helpful

[@shubh0707]

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

[@semikolon4229]

This video is pure GOLD.

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

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

[@vinayakacn401]

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

[@deepthimurali962]

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

[@ankitbansal6]

That's great 😊

[@pragatidutta9470]

Best video on joins👍🏽

[@pranaykukadkar7092]

The real content of SQL

[@RajChoudhary-jm9io]

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

[@siddhantgarg2051]

Best video for the topic❤️

[@vikramr9437]

Excellent video sir, I got same question in interview.

[@shakthimaan007]

This is awesome

[@NaveenKumar-cn2pc]

Well explained thank you for this great video

[@gunasekharp5027]

Really great video ....the best video i have seen so far

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

[@nikhilchoudhary7860]

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

[@ankitbansal6]

Glad to hear that

[@EMRANKhan-q8x]

Well Explained...

[@madhumms]

Most helpful with these scenarios. Thanks a lot

[@rahulpawar5945]

Awesome all doubts are clear..thanks

[@gouravkumar9011]

amazing explanation by Ankit paaji

[@nishantverma2966]

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

[@ankitbansal6]

Glad to hear that

[@cheequsharma7391]

Very good example and explanation. 👍

[@ankitbansal6]

Glad it helped!

[@ishanbhatnagar8290]

Awesome video and explain it very well.thank you.

[@abhi1994100]

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

[@aanavourjoy]

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

[@ankitbansal6]

My pleasure

[@DeepshikhaMeena-g2i]

Very well explained

[@Telugufun427]

good explanation i understood my doubts now

[@Urmilavijay20]

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

[@mohammeddanish8624]

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

[@ankitbansal6]

You're welcome!

[@sudhanshubhardwaj9325]

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

[@pratibhamishra869]

Absolutely perfect video on this topic.

[@ankitbansal6]

Thank you 😊

[@Ak12345-g]

I have fair understanding of joins by this ankit❤

[@hijamgyaneswarsingh879]

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

[@nagendras9696]

Great explanation Sir 🥳🥳🥳