mysql - SQL WHERE 不过滤我的结果

Question

我想过滤掉小于 3 的结果，但每当我添加 WHERE 语句时，查询都会失败。我的查询有什么问题？我正在使用 MySQL Workbench 3.7

SELECT c.name, COUNT(DISTINCT s.product_id) AS veggies  
FROM sales AS s
INNER JOIN customers AS c
ON c.id=s.customer_id
GROUP BY s.customer_id
WHERE veggies > 2"

谢谢!阴户

Answer 1

where 应该是having:

SELECT c.name, COUNT(DISTINCT s.product_id) AS veggies
FROM sales s INNER JOIN
     customers c
     ON c.id = s.customer_id
GROUP BY s.customer_id
HAVING veggies > 2;

您的查询要么生成了语法错误(即未运行)，要么在 GROUP BY 处停止并忽略了 WHERE。