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


    âš¡ Month End Offer - Flat 52% Off On All Courses! Enroll Now âš¡
    00:00:00 AM Left

    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