请帮我看看这个查询语句有什么错误
来源:百度知道 编辑:UC知道 时间:2024/05/06 01:42:04
ELECT * bmbh
FROM hp_zd01
GROUP BY bmbh
HAVING COUNT bmbh > 1
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 是什么?用×号还加字段做什么?