dior2017秋冬时装秀:请帮我看看这个查询语句有什么错误

来源:百度文库 编辑:中科新闻网 时间:2024/05/01 05:50:38
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 是什么?用×号还加字段做什么?