7.6 Cartersian Product in SQL Query in DBMS

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: ruclips.net/video/YRnjGeQbsHQ/видео.html

[@arshandubey]

I was so confused about this topic, and after watching this video, my all doubts got cleared. !!!

[@KNOWLEDGEGATE_kg]

Very good, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg
🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@156sparsh7]

Sir while u explain everything well some of the topics like tuple and domain calculus and inner join in relational algebra are missing also how to converter the model to a relational model. Plz add these sir it would help us a lot

[@KNOWLEDGEGATE_kg]

Dear @Sparsh, if you are looking for complete detail & topics on DBMS, you can check out our complete DBMS course on the link given below:
www.knowledgegate.in/learn/DBMSbysanchitsir

[@ujjwaljain9780]

ya aaj samaj me aaya......thanku sir

[@souravkundu7051]

Best teacher and very easy explaining

[@sahilmadaan1]

Thank you sir... i understood it in one go

[@saddamahmad2310]

thank you very much sir for this video

[@Tanush-od5nj]

sir on 8 53 i think you made mistake you told branch name north delhi but north delhi should be branch city not branch name

[@NishaSharma-nd1dk]

Thanks sir g

[@rampunasiya1848]

Sirji love you ❤

[@dhruvpolara8487]

sir lekin borrower table me dipositor vale customer to nahi hoge to fir vo to chut jayenge to usake liye kya kare ??

[@Sudeshsorout]

Dhanyabad sir g

[@dattatreyapujar4068]

Sir now a days you aren't replying to any of the comments unlike before..

[@lakshaykakkarr]

If Table1 has m rows and Table 2 has n rows, will the cartesian product of these two have m + n rows or m x n rows?

[@devashishbawa8236]

m + n

[@PriyaSingh-ex8ps]

we will get m*n rows but m+n columns

[@jellyfish1772]

thank you sir

[@KNOWLEDGEGATE_kg]

You are most welcome! Keep learning & stay connected! You can also check out our website www.knowledgegate.in for more amazing videos & contents👍😊

[@minivashishta9288]

thank you,sir

[@rajutkarshgupta]

Correction : Cartesian product will give m*n tuples

[@sairajdas6692]

he said columns

[@niteshtrading]

Yeah you're right but m+n columns he said.

[@dhruvishah9077]

Sir can we write like,.
Select cname from customer where branch_name IN (Select branch_name from branch where branch_name='ND')

[@lovleshbhatt7797]

Noo, the attribute which you write after where clause should be the part of the attribute , here branch_name is not part of customer so can't access this attribute buddy!!

[@thesportslightmaker5988]

thank u sir

[@GadgetMeta]

Sir can you please upload video series about
Microprocessor 8085

[@sushil_advisor]

watch this playlist on Microprocessor ruclips.net/p/PLS8ACsmFCpmQahmUVlcUYGUbqNd3usKct

[@devenpatel4684]

But sir branch name are common for some account no

[@Sudeshsorout]

Dosto paper Download kese Karna h yaha se dekhe ..... Mene samjhane ki kosis ki h 👍👍👍 ruclips.net/video/AWEotINldIc/видео.html

[@AbhishekKumar-pf5mg]

Thanks sir