COALESCE ( expression,value1,value2……,valuen)
含义:返回其参数中第一个非空表达式
如果value1不为空值则返回value1;
否则判断value2是否是空值,如果value2不为空值则返回value2;
……以此类推,如果所有的表达式都为空值,则返回NULL。
使用:
SELECT
cur_time AS countDate,
COALESCE ( sum( sign_cur_add ), 0 ) AS signTotal,
COALESCE ( sum( sign_cur_add - family_cur_add ), 0 ) AS signCommon,
COALESCE ( sum( family_cur_add ), 0 ) AS signFamily,
COALESCE ( SUM( sign_total_count ), 0 ) AS historySignTotal
FROM
table1
结果:
实际应用时防止返回参数为空