hard20 pts · first answer countssqljoinsreconciliation
FULL OUTER JOIN row count
Table a has keys 1, 2, 3. Table b has keys 2, 3, 4, 4. How many rows does this query return?
SELECT COUNT(*) FROM a FULL OUTER JOIN b ON a.k = b.k;
Table a has keys 1, 2, 3. Table b has keys 2, 3, 4, 4. How many rows does this query return?
SELECT COUNT(*) FROM a FULL OUTER JOIN b ON a.k = b.k;