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

  • google app store apple app store
  • ✖

      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