mysql 问题用sum，group by加上where的时候，会用空结果集合，而我想显示为0

Question

Answer 1

可以用ifnull：ifnull(sum(price),0) as total

Answer 2

用COALESCE。

SELECT COALESCE(SUM(price), 0) AS total FROM …