The column contains both values and missing values. Will SUM function work for such columns by ignoring those null values?Thanks.

Hi Christine Li! Thanks for reaching out. In MySQL, SUM() is supposed to ignore null values. In any case, if you want to be specific, you can instruct the SQL Optimiser to substitute the null values with the value of 0. To do that, you can help yourself with the COALESCE() function and the following model: SELECT COALESCE(SUM(column_name), 0) ... Hope this helps. Best, Martin

Follow this topic

Christine Li

Last answered:

03 Apr 2022

Posted on:

26 Mar 2022

SUM for columns with null values

in SQL / SUM()

1 answers ( 0 marked as helpful)

Martin Ganchev

Posted on:

03 Apr 2022

SUM for columns with null values

Submit an answer

related questions