In SQL the statement select ∗ from R, S is equivalent to
2023
In SQL the statement select ∗ from R, S is equivalent to
Answer: B. Select ∗ from R cross join S — The SQL statement SELECT * FROM R, S performs an implicit Cartesian product between tables R and S. This operation generates all possible row combinations…
- A.
Select ∗ from R natural join S
- B.
Select ∗ from R cross join S
- C.
Select ∗ from R outer join S
- D.
Select ∗ from R inner join S
Attempted by 807 students.
Show answer & explanation
Correct answer: B
The SQL statement SELECT * FROM R, S performs an implicit Cartesian product between tables R and S. This operation generates all possible row combinations without any filtering conditions, which is functionally identical to an explicit CROSS JOIN statement in modern SQL standards.
Loading lesson…