SQL - Advanced Joins
If table A has 3 rows and table B has 4 rows, how many rows will the result have after a
CROSS JOIN of A and B?If table A has 3 rows and table B has 4 rows, how many rows will the result have after a CROSS JOIN of A and B?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Calculate rows in each table
Table A has 3 rows, Table B has 4 rows.Step 2: Multiply rows for CROSS JOIN
CROSS JOIN returns the Cartesian product, so total rows = 3 * 4 = 12.Final Answer:
12 rows -> Option BQuick Check:
Rows after CROSS JOIN = 3 * 4 = 12 [OK]
Quick Trick: Multiply row counts of both tables for CROSS JOIN result [OK]
Common Mistakes:
MISTAKES- Adding row counts instead of multiplying
- Confusing with INNER JOIN row count
- Assuming result equals smaller table row count
Master "Advanced Joins" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes