我的购物袋:请帮我看看这个查询语句有什么错误

来源:百度文库 编辑:高考问答 时间:2024/05/14 12:40:14
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 是什么?用×号还加字段做什么?