Question

If table A has m rows and table B has n rows then how many rows will the following query return

SELECT A.A1,B.B1
FROM A,B
WHERE A.A3=B.B3​

Answer 1

Answer:

If table A has m rows and table B has n rows then how many rows will the following query return 2

Answer 2

SELECT A.A1,B.B1

FROM A,B

WHERE A.A3=B.B3​

In the query return row

• When all of the key values are the same, the most rows are produced. The greatest number in this situation is m * n, and the inner join is identical to a cross join.
• With the exception that an outside join is guaranteed to deliver results even when one of the tables is empty, the maximum number for both left and right outer joins is essentially the same.
• Therefore, the maxima are written as greatest(m, n, m * n).

#SPJ3