There are two tables, customer table has 5 rows and the order table has 8 rows. How many will be generated when the following query is executed against the database :-
select *
from tbl_customer, tbl_order;
Interview question and answer by:
Akiii | Posted on: 5/31/2012 | Category:
SQL Server Interview questions | Views: 1149 | |
Points: 40
Select from following answers:- 10 rows
- 40 rows
 - 5 rows
- 8 rows
40 rows will be generated because it simply cross product the table(there is no where condition here). So for each row of the customer table, there will be 8 rows associated from the order table.
That is, 5 * 8 = 40 rows
Thanks and Regards
Akiii
 Show Correct Answer |
Found interesting? Add this to: