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 @ Rs 1999 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/courses/SQL-For-Analytics-6301f405e4b0238f71788354 The course contains 2 portfolio projects and a bonus session on Tableau. 100+ 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 :)

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

[@kavitapawar2524]

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

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

[@pathipakasanthoshkumar5730]

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

[@sunitasahu307]

Great Explanation covering all scenarios, it's really helpful

[@mohanbabu3030]

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

[@sushmamc8904]

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

[@shubhamjaiswal3799]

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

[@ishanbhatnagar8290]

Awesome video and explain it very well.thank you.

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

[@NaveenKumar-cn2pc]

Well explained thank you for this great video

[@sudan9393]

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

[@bhumikasoni361]

Awesome video, It gives good clarity with easy explanation

[@diwakarchaurasia]

Great video. Very useful information!

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

[@sonip472]

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

[@spark9_]

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

[@sonajiwagh6430]

Thanks a lot for sharing great knowledge...........

[@abhi1994100]

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

[@hijamgyaneswarsingh879]

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

[@luckyagrawal6029]

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

[@hungerspoint7358]

Awesome video!! Explanation is crystal clear. Thanks

[@mohammadasim6574]

Amazing work. Thanks for putting this here.

[@RajChoudhary-jm9io]

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

[@anjalipandey3730]

amazing explanation. Thank you for the video.

[@madhumms]

Most helpful with these scenarios. Thanks a lot

[@venkateshwaranp5130]

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

[@SunilKumar_67]

Truly amazing content

[@RAJANKUMAR-tl9xc]

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

[@SuperMohit95]

Very insightful video as always!

[@harish1838]

Came here after seeing your recent linkedin post completely enjoying it

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

[@PratikPictures]

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

[@Ninjabear7]

Thank you Aditya. Very helpful.

[@gunasekharp5027]

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

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

[@suhassajjan4056]

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

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

[@susmitadolas5178]

Very helpful Video. Thanks!

[@venkateshkurnool6124]

Nice information and explanation

[@roronoazoro1755]

Great Work !!! Thanks for the clear explaination😃

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

[@semikolon4229]

This video is pure GOLD.

[@rahulpawar5945]

Awesome all doubts are clear..thanks

[@yogitashinde2036]

Thank You So Much For This Concept😊.

[@NitinMohanSharmanms]

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

[@surik972]

Great way of explanation!! Keep it up!! It will be more useful even for a novice!!

[@dollysingh9364]

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

[@SONU1476]

Thank you Cleared the doubts .. Wonderful Man 😊

[@uditprajapati5396]

Simply, Awesommme :) ,Crystal Clear Ankit...Thank you so much 👌

[@bhupendrasharma386]

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

[@Telugufun427]

good explanation i understood my doubts now

[@siddhantgarg2051]

Best video for the topic❤️

[@suryakanthbhullha7425]

Very help full, thanks.

[@vikramr9437]

Excellent video sir, I got same question in interview.

[@nagendras9696]

Great explanation Sir 🥳🥳🥳

[@monasanthosh9208]

Awesome Explanation

[@sudhanshubhardwaj9325]

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

[@cajonnoob]

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

[@subhashdixit5167]

Great sir. Thank you so much

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

[@CHANDUSAIHEMANTH]

Thank you so much for the detailed explanation. It helped me a lot.

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

[@mohitarora9742]

Dude, thanks a lot.. I faced this questions in at least last 10 interviews

[@ankitkanojia226]

Thank you very much , I am looking for this video.

[@dayal4256]

Fantastic Explanation

[@TrustinData]

Tqsm for awesome explanation.Wishing you more success🔥🔥

[@GovindSingh-gd5jz]

Helped me in my interviews, thanks buddy

[@shaileshsingh1445]

awesome champion !!!

[@rajveerdhumal3143]

Simply amazing bhai

[@AISHWAR04]

This is so helpful!..Thanks Ankit!

[@pragatidutta9470]

Best video on joins👍🏽

[@cricbolly3252]

Great 👍 work brother

[@jobanu7527]

Thank you so much Ankit for this tutorial!! This is really great

[@vikasbabu4497]

Great stuff as always

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

[@lithishk7052]

Thank you so much for explaining clearly.

[@bandhammanikanta6302]

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

[@rajveerdhumal3143]

You are doing great job bhai

[@girishdepu4148]

nice content

[@jamisurendra9141]

Thanks Ankit for detail explaination

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

[@pranavdhuri2710]

Great explaination !

[@shivamadolia3144]

Great job done!

[@sarbanibanerjee573]

Very good video

[@sachinkv6972]

great man

[@The_Bold_Statement]

excellent explaination

[@koushikdey100]

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

[@davidlaid-ur9xn]

Liar

[@minute_syntax]

great video sir...

[@sonichauhan1643]

Thanks for this one!

[@ronakchoudhary7089]

Awesome

[@rushikeshpamu3550]

Amazing 👏

[@pavankushoba5885]

Loved it sir

[@aliatifsyed6167]

very helpful.... thankyou

[@shubh0707]

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

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

[@jasleenkaur-cw2fw]

Excellent explanation !