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


    Question

    What is the output of this SQL snippet if the price

    column contains NULL values? SELECT SUM(price) FROM products;
    A SUM of all prices including NULL Correct Answer Incorrect Answer
    C NULL Correct Answer Incorrect Answer
    D Error Correct Answer Incorrect Answer
    E SUM of non-null prices Correct Answer Incorrect Answer

    Solution

    Aggregate functions like SUM() ignore NULL values.

    Practice Next
    ask-question