合同完成情况怎么填写:请帮我看看这个查询语句有什么错误

来源:百度文库 编辑:查人人中国名人网 时间:2024/04/20 20:29:33
ELECT * bmbh
FROM hp_zd01
GROUP BY bmbh
HAVING COUNT bmbh > 1

单表查询里from前用了*号,后面就不要再限制查询字段了。
SELECT *
FROM hp_zd01
GROUP BY bmbh
HAVING COUNT (bmbh) > 1

SELECT bmbh
FROM hp_zd01
GROUP BY bmbh
HAVING COUNT (bmbh) > 1

SELECT * bmbh
FROM hp_zd01
GROUP BY bmbh
HAVING COUNT (bmbh) > 1

ELECT 是什么?用×号还加字段做什么?