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

[@rps9167]

One of the best!

[@ssunitech6890]

Thanks 🙏

[@priyabhandarkar6958]

Very nice explanation 👏👏

[@ssunitech6890]

Thanks,
Please share to others

[@neetstudybyaps7125]

Nice ❤

[@ssunitech6890]

Thanks 🙏

[@goluSingh-su1xs]

Simple ❤️

[@ssunitech6890]

Thanks 🙏

[@ankitmurela5554]

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

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

[@manishkumarsingh2254]

Yes this is the most common question.

[@ssunitech6890]

Thanks 🙏

[@barotpriyanka]

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.

[@vijayamutyala4213]

How to contact you

[@ssunitech6890]

Call me 📞 [phone]