例: select SUM(1+null)结果为null select COALESCE(SUM(1+null),0) 结果为0 转载于:https://www.cnblogs.com/bingle/archive/2013/04/16/3023505.html