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.

[ankitbansal]

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.

The course contains 2 portfolio projects and a bonus session on Tableau.

50+ interview problems to crack any SQL INTERVIEW.

[aakriti_]

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

[sandeepreddy]

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.

[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

[PradyutJoshi]

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

[kavitapawar]

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

[pathipakasanthoshkumar]

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

[luckyagrawal]

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

[sushmamc]

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

[sunitasahu]

Great Explanation covering all scenarios, it's really helpful

[mohanbabu]

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

[shubhamjaiswal]

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

[sonip]

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

[NaveenKumar-cnpc]

Well explained thank you for this great video

[spark_]

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

[hijamgyaneswarsingh]

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

[ishanbhatnagar]

Awesome video and explain it very well.thank you.

[deepshikhamishra]

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 🙏

[ritikajaiswal]

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

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