周星驰白发是真的吗:请帮我看看这个查询语句有什么错误

来源:百度文库 编辑:神马品牌网 时间:2024/05/02 09:02:27
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 是什么?用×号还加字段做什么?