What is the difference between Union and Union all statements

technology databases

  1. Union all used for combining multiples queries using single union all

  2. There is no difference

  3. the union will eliminate duplicate records in result set but, union all will print the duplicate records

  4. Union all is used for select with multiple columns

Show answer
Correct Option: C

Find more quizzes: