Total Page Preview: 000000003553
What is cross join in SQL in English and Hindi
Cross join in English
In SQL, a cross join, also known as a cartesian product, is a type of join that combines each row from one table with every row from another table. This results in a new table that has every possible combination of rows from the two tables.
The basic syntax of a cross join is as follows:
Here is an example of a cross join:
Suppose we have two tables, Table1 and Table2, as shown below:
Table1:
Table2:
If we perform a cross join between Table1 and Table2, the resulting table would have four rows, as shown below:
As you can see, the resulting table contains every possible combination of rows from Table1 and Table2.
Cross join in Hindi
SQL me, cross join (ya cartesian join) ek join hai jo ek table ke har row ko dusre table ke har row ke saath combine karta hai. Isse do tables ke har possible combination se ek naya table banta hai.
Cross join ka basic syntax is tarah hota hai:
Yahan ek cross join ka example diya gaya hai:
Maan lijiye hamare paas do tables hai, Table1 aur Table2, jaisa ki niche dikhaya gaya hai:
Table1:
Table2:
Agar hum Table1 aur Table2 ke beech ek cross join karte hain, to resulting table mein chaar rows honge, jaisa ki niche dikhaya gaya hai:
Jaise ki aap dekh sakte hain, resulting table mein Table1 aur Table2 ke har possible combination ka data shamil hai. Cross join is tarah ke scenarios me upyogi ho sakta hai jahan data ke saare combinations generate karne ki zaroorat ho.
Thank You
About Author
Brijesh Kumar
Database Developer
I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL
Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall
and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com