如何在mysql中对同一字段进行多次计数?下面的代码一次计数可以正常工作
SELECT fruit, COUNT(DISTINCT site) AS `apple` FROM grocery where fruit like '%06201%'
但是,当我尝试过此操作却收到语法错误时
SELECT
SUM(fruit like '%06201%') AS `apple`,
SUM(fruit like '%02206%') AS `pears`,
FROM grocery
SELECT
SUM(fruit like '%06201%') AS `apple`,
SUM(fruit like '%02206%') AS `pears`,
^
here
FROM grocery
您有两个逗号,但您只需要一个。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句