Multiple choice technology mainframe

Difference between UNION and UNION ALL.

  1. Union wont remove the duplicate and it wont invoke the sort operation.

  2. Union all will remove the duplicate and it wont invoke the sort operation.

  3. Union won't remove the duplicate and it will invoke the sort operation.

  4. Union all will remove the duplicate and it will invoke the sort operation.
Reveal answer Fill a bubble to check yourself
A Correct answer

Keep practicing — related questions