Assume a schema of
Emp ( Id, Name, DeptId ) , Dept ( Id, Name).
If there are 10 records in the
Emp table and 5 records in the
Dept table, how many rows will be displayed in the result of the following SQL query:
Select * From Emp, Dept
Explain your answer.
The query will result in 50 rows as a “cartesian product” or “cross join”, which is the default whenever the ‘where’ clause is omitted.