MS SQL Server Joins Question: Download Questions PDF
What is cross join in SQL server joins?
Answer:
A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table. The common example is when company wants to combine each product with a pricing table to analyze each product at each price.
Download SQL Server Joins Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain a join? | What is Inner Join in SQL server joins? |