ЁЯУв 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
    More SQL Questions
    ask-question