most asked scenario based sql Interview question & answer | no of Records of 5 types of joins

[@swarooppabbineedi1820]

The same question was asked to me. May be that interviewer watched this video and asked me that question along with the same values. I know about joins concept but could able to answer it.. Thanks for the video.

[@ssunitech6890]

Thanks for your appreciation

[@anjaneyulukollipara-v5f]

nice & simple...upload more videos

[@ssunitech6890]

Thanks 🙏

[@vaibhavdalvi8570]

Awsm approach to teach

[@ssunitech6890]

Thanks 😊

[@RK-wf7re]

Good content, in right outer sequence should be 3,3,2,2,2 right or am I doing something wrong. Plz correct me if I am wrong

[@balajihero]

yes same doubt 3,3,2,2,2,1,1

[@lavanyapodili5234]

You are right

[@priyabhandarkar6958]

Very nice explanation 👏👏

[@ssunitech6890]

Thanks,
Please share to others

[@ManoSru]

Clear and Perfec❤❤❤

[@ssunitech6890]

Thanks 🙏

[@manishkumarsingh2254]

Yes this is the most common question.

[@ssunitech6890]

Thanks 🙏

[@harinadhbabu309]

Well explained, Thank you 🙏

[@ssunitech6890]

Thanks
Keep sharing 😀

[@RPS_Tomar]

One of the best!

[@ssunitech6890]

Thanks 🙏

[@anky986]

Please make a video on query optimization step by step

[@ssunitech6890]

Sure

[@HariKrishna-rf8eq]

Sir Can you please do video on query optimization

[@ssunitech6890]

Sure

[@neetstudybyaps7125]

Nice ❤

[@ssunitech6890]

Thanks 🙏

[@BrokenRecord-i7q]

literally was asked twice - paytm and zepto

[@ssunitech6890]

Yes it's very common question

[@WolfmaninKannada]

Tq sir

[@ssunitech6890]

Thanks

[@goluSingh-su1xs]

Simple ❤️

[@ssunitech6890]

Thanks 🙏

[@Moonlight-_6.1]

How about space ?

[@ssunitech6890]

What space??

[@lkkota41]

thank u for explaining,,,Can some please explain below

Table1 Table2 inner join left join right full join cross join
Sample1 52 Sample1 52 1 5 7 9 10 49
Sample2 53 Sample21 53 0
Sample1 48 Sample11 48 1
Sample3 48 Sample22 70 1
Sample4 52 Sample3 48 0
Sample5 54 Sample41 52 1
Sample5 20 Sample5 54 1
SQL query for full join is showing 11 records and I see NULL values.. NOT sure why
Name age
Sample1 52
Sample2 53
Sample1 48
Sample3 48
Sample4 52
Sample5 54
Sample5 20
NULL NULL
NULL NULL
NULL NULL
NULL NULL

[@komalchaudhari7067]

I didn't get full join

[@ssunitech6890]

It's multiplication of no of rows in left and right tables.
Eg- 4 rows in left, and 5 rows in right then output will be 4×5=20.

[@minalgupta189]

@@ssunitech6890 this is cross join not full join right if you are multiplying

[@vijayamutyala4213]

How to contact you

[@ssunitech6890]

Call me 📞 [phone]