Question

提示我“SQL: 缺少GROUP BY 子句或子句无效” 请问是为什么？？

SELECT 员工.*, COUNT(销售.编号) AS 受理业务总次数;
FROM 员工 LEFT JOIN 销售 ON 员工.编号=销售.编号;
GROUP BY 销售.编号;
ORDER BY 受理业务总次数 DESC

Answer 1

group by 后面不能有计算列,如COUNT()
SELECT 员工.*, COUNT(销售.编号) AS 受理业务总次数;
FROM 员工 LEFT JOIN 销售 ON 员工.编号=销售.编号;
GROUP BY 员工.*
ORDER BY 受理业务总次数 DESC

Answer 2

员工.*里面有没聚合的字段值。