mysql - WHERE子句导致Mysql查询语法错误

Question

考虑(银行的)表格:

账户

客户

我想返回所有拥有更多客户 ID 的客户不止一个银行账户

我的建议:

SELECT c.Client_id_number , c.firstName_client , c.lastName_Client , COUNT(a.Account_number) as number_of_accounts
FROM Clients AS c
LEFT JOIN Accounts AS a
ON a.Client_id_number = c.Client_id_number
GROUP BY Client_id_number
WHERE number_of_accounts >= 2;

但是 WHERE 子句会导致语法错误。为什么 ？

Answer 1

SELECT c.Client_id_number , c.firstName_client , c.lastName_Client , COUNT(a.Account_number) as number_of_accounts
FROM Clients AS c
LEFT JOIN Accounts AS a
ON a.Client_id_number = c.Client_id_number
GROUP BY Client_id_number
HAVING COUNT(a.Account_number) >= 2;

<强> See this for correct SQL clasues order