most asked scenario based sql Interview question & answer

No video

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

Рет қаралды 21,958

Жыл бұрын

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 KZfaq- "Subscribe Channel to watch Database related videos" / @ssunitech6890
For SQL Quiz-
• sql server : Interview...
Find Us On FaceBook-
/ ss-unitech-18770538867...

Пікірлер: 34

@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 4 күн бұрын

Well explained, Thank you 🙏

@ssunitech6890 4 күн бұрын

Thanks Keep sharing 😀

@vaibhavdalvi8570 21 күн бұрын

Awsm approach to teach

@ssunitech6890 21 күн бұрын

Thanks 😊

@priyabhandarkar6958 6 ай бұрын

Very nice explanation 👏👏

@ssunitech6890 6 ай бұрын

Thanks, Please share to others

@rps9167 Жыл бұрын

One of the best!

@ssunitech6890 Жыл бұрын

Thanks 🙏

@RK-wf7re 9 ай бұрын

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 8 ай бұрын

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

@lavanyapodili5234 6 ай бұрын

You are right

@WolfmaninKannada Ай бұрын

Tq sir

@ssunitech6890 Ай бұрын

Thanks

@manishkumarsingh2254 Жыл бұрын

Yes this is the most common question.

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

@lkkota41 10 күн бұрын

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