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

SQL Tips and Tricks
In this video we will discuss SQL Join based interview question where you need to tell no of records in output when you are joining of 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.
Find Us On UA-cam- "Subscribe Channel to watch Database related videos" / @ssunitech6890
For SQL Quiz-
• sql server : Interview...
Find Us On FaceBook-
/ ss-unitech-18770538867...

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

[@harinadhbabu309]

Well explained, Thank you 🙏

[@ssunitech6890]

Thanks
Keep sharing 😀

[@vaibhavdalvi8570]

Awsm approach to teach

[@ssunitech6890]

Thanks 😊

[@RPS_Tomar]

One of the best!

[@ssunitech6890]

Thanks 🙏

[@priyabhandarkar6958]

Very nice explanation 👏👏

[@ssunitech6890]

Thanks,
Please share to others

[@anky986]

Please make a video on query optimization step by step

[@ssunitech6890]

Sure

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

[@manishkumarsingh2254]

Yes this is the most common question.

[@ssunitech6890]

Thanks 🙏

[@WolfmaninKannada]

Tq sir

[@ssunitech6890]

Thanks

[@neetstudybyaps7125]

Nice ❤

[@ssunitech6890]

Thanks 🙏

[@goluSingh-su1xs]

Simple ❤️

[@ssunitech6890]

Thanks 🙏

[@HariKrishna-rf8eq]

Sir Can you please do video on query optimization

[@ssunitech6890]

Sure

[@shivayshakti6575]

literally was asked twice - paytm and zepto

[@ssunitech6890]

Yes it's very common question

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

[@Moonlight-u9u]

How about space ?

[@ssunitech6890]

What space??

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