Assume a schema of Col ( Id, Name, DeptId ) , Dept ( Id, Name)

If there are 10 records in the Col table and 5 records in the Dept table, how many rows will be displayed in the result of the following SQL query:

Select * From Col, Dept
asked in Database Questions by
0 votes

1 Answer

answered by

The query will result in 50 rows as a cartesian product or cross join, which is the default whenever the ‘where’ clause is omitted.

0 votes