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.

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

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

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.

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

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

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

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

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

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

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.

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. 😀

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

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😊

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

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

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

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

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

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

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

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

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 🙏

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

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.

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

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

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

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

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

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

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

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

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

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

Great Explanation covering all scenarios, it's really helpful

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

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

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

The real content of SQL

This is really helpful to those going for SQL interviews.

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

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

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

Awesome video, It gives good clarity with easy explanation

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

Very good example and explanation. 👍

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

Great explanation Can answer any type of join scenarios

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

Its full descriptive ! Keep it up

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

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

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

Came here after seeing your recent linkedin post completely enjoying it

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

Right now I'm regretting why I haven't watch this video last night, today I had cleared the interview. BTW its great video thanks 🙏

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

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

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

Very Clear explanation..Thanks, Sir

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.🎉

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

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

Thanku, I just learnt today only that null is not equal to null.

This is the best free software Ive seen. Respect.

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

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 )

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

Awesome video and explain it very well.thank you.

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 .

Great explanation Sir 🥳🥳🥳

Thank You So Much For This Concept😊.

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

This is awesome

Most helpful with these scenarios. Thanks a lot

This video is pure GOLD.

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

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

Very good video

Amazingly explained…Ty so much👍🏻

Excellent video sir, I got same question in interview.

Great video. Very useful information!

Amazing work. Thanks for putting this here.

Well explained thank you for this great video

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

Very well explained.thanks

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

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

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

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

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

Thanks for the great video! Nice concept explanations and Clear cut presentation!

amazing explanation. Thank you for the video.

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

Simple and nice explanation

Such a simple and great explanation! Thank you !!

Great explanation Sir 👍 Thanks a lot

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

Thank you Cleared the doubts .. Wonderful Man 😊