easy5 pts · first answer countssql
UNION vs UNION ALL
Table a has values (1), (2), (2) and table b has (2), (3). How many rows does this return?
SELECT x FROM a UNION SELECT x FROM b;
Table a has values (1), (2), (2) and table b has (2), (3). How many rows does this return?
SELECT x FROM a UNION SELECT x FROM b;