Tables EMP and MANAGER has 5 records each.
How many rows will the following query return?
SELECT * FROM EMP, MANAGER
Answer:
25 rows. Each rows in EMP will have five rows of MANAGER which makes 5×5 = 25.
Tables EMP and MANAGER has 5 records each.
How many rows will the following query return?
SELECT * FROM EMP, MANAGER
Answer:
25 rows. Each rows in EMP will have five rows of MANAGER which makes 5×5 = 25.