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

    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
    More SQL Questions
    ask-question