我想从表中选择分组计数大于 5 的所有记录

Question

我想从一个表中获取所有记录，其中 agent_no = 70 并按 home_number,agent_no 分组有计数（*）> 1

SELECT 

*

FROM user_data

WHERE agent_no = 70

GROUP BY

  home_number,

  agent_no

HAVING COUNT(*) > 1

SQL 查询：文档

SELECT 

*,

COUNT(*) AS count

FROM voters_data

WHERE booth_no = 70

GROUP BY

  hno,

  booth_no

HAVING COUNT(*) > 1 LIMIT 0, 25

MySQL 说： 文档

1064 - 你的 SQL 语法有错误；检查与您的 MySQL 服务器版本相对应的手册，了解在第 4 行的 'COUNT(*) AS count FROM voters_data WHEREbooth_no = 70 GROUP BY hno, bo' 附近使用的正确语法

Answer 1

在booth_no 后面缺少一个逗号....booth_noCOUNT(*) AS count....应该....booth_no,COUNT(*) AS count....

Answer 2

您需要返回字段。SELECT COUNT(*), home_number, agent_no FROM user_data WHERE agent_no = 70 GROUP BY home_number, agent_no HAVING COUNT(*) > 1