SQL中SUM函数如何处理NULL值

Question

数字相加和表sum求和区别

select 1+null
select sum（num） from table

table
ID num
1 1
2 null

Answer 1

select sum(if(num is null, 0 ,num)) from table