mysql查询语句假如数值为null，就默认显示0
先来看一下需求：sql语句：selectdate_format(creatTime,"%Y-%m-%d") as days,count(id) as num,sum(money) as moneyfrom `order` group bydays;结果如下：解决方法： 使用 CASE WHEN 字段 IS NOT NULL THEN 值 ELSE 0 END示例...
·
先来看一下需求：
sql语句：
select date_format(creatTime,"%Y-%m-%d") as days,count(id) as num,sum(money) as money
from `order` group by days;结果如下：
解决方法： 使用 CASE WHEN 字段 IS NOT NULL THEN 值 ELSE 0 END
示例代码：
select date_format(creatTime,"%Y-%m-%d") as days,count(id) as num,
(CASE WHEN SUM(money) IS NOT NULL THEN SUM(money) ELSE 0 END) AS money
from `order` group by days;最终效果：
无需安装部署，在线快速体验 Byzer
更多推荐
0
0- 0
已为社区贡献2条内容
所有评论(0)