| |
GeekInterview.com > Interview Questions > Mainframe > DB2
| Print | |
Question: How many rows will the query return ?
Answer: Table1 has 6 rows and Table2 has 6
SELECT * FROM Table1, Table2;
a.6
b.12
c.36
d.720
e.Cannot say
rows.
36
|
| September 09, 2008 01:44:21 |
#1 |
| prasenjit_in |
Member Since: April 2008 Total Comments: 12 |
RE: How many rows will the query return ?
|
| We cannot say since the query will act like an inner join, so all matching rows of both table will be fetched...so cannot say for sure how many rows do match in both table! |
| |
Back To Question | |
