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


    Question

    Which of the following SQL constructs avoids returning

    duplicate rows?
    A HAVING Correct Answer Incorrect Answer
    B DISTINCT Correct Answer Incorrect Answer
    C GROUP BY without aggregates Correct Answer Incorrect Answer
    D LIMIT Correct Answer Incorrect Answer
    E ORDER BY Correct Answer Incorrect Answer

    Solution

    DISTINCT removes duplicate rows in the result set.

    Practice Next
    ask-question