📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

  • google app store apple app store
  • âś–

      Question

      Which SQL statement combines the results of two queries

      and removes duplicates?
      A JOIN Correct Answer Incorrect Answer
      B UNION Correct Answer Incorrect Answer
      C INTERSECT Correct Answer Incorrect Answer
      D EXCEPT Correct Answer Incorrect Answer
      E MERGE Correct Answer Incorrect Answer

      Solution

      UNION merges two query results into a single result set and automatically removes duplicates.

      Practice Next
      ask-question