Rajanikant Hawaldar
How many records will be there in the result set of a CROSS JOIN?

How many records will be there in the result set of a CROSS JOIN?

By Rajanikant Hawaldar in SQL Server on Mar 07 2021
  • Kiran Mohanty
    Mar, 2021 8

    Result count is same as cartesian product of results from two table.

    The Cartesian Product is a multiplication operation in the set theory that generates all ordered pairs of the given sets.

    • 2
  • Rajeev Kumar
    Mar, 2023 17

    Cross join :Cross Joins produce results that consist of every combination of rows from two or more tables. That means if table A has 3 rows and table B has 2 rows, a CROSS JOIN will result in 6 rows. There is no relationship established between the two tables

    • 0
  • Murali Krishnan
    May, 2021 21

    IF you have 5 rows in table A. and 8 rows in tables C. then the result will be 40 rows will be in cross jo

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS