select sum(price) as price from order where status='SUCCESS';
如果price对应的所有的值为0,那么算出来的和为null;
可以采用ifnull关键字解决
select ifnull(sum(price),0) from order where status='SUCCESS';
select sum(price) as price from order where status='SUCCESS';
如果price对应的所有的值为0,那么算出来的和为null;
可以采用ifnull关键字解决
select ifnull(sum(price),0) from order where status='SUCCESS';
转载于:https://www.cnblogs.com/sonofelice/p/6149886.html