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


    Question

    Which operator is used to combine results of two SELECT

    queries and remove 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 results from two queries and eliminates duplicate rows by default.

    Practice Next
    ask-question