{CodeRoyale}
All challenges
Multiple ChoiceIntermediate 30s

UNION vs UNION ALL

Choose the best answer for: UNION
Options
  1. 1UNION ALL removes duplicates, while UNION keeps them
  2. 2UNION combines columns side by side instead of rows
  3. 3UNION removes duplicates; UNION ALL keeps them
  4. 4They are identical; both remove duplicates the same way
backendintermediate

Think you can answer under pressure?

Get matched and answer live questions in 3-minute 1v1 battles. Elo ranking, badge tiers and bragging rights on the line.

Play this in a 3-minute battle