Difference between UNION and UNION ALL.

technology mainframe

  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.

Show answer
Correct Option: A

Find more quizzes: