石家庄数学编辑招聘:请高手帮我看一下这个查询语句有何错误
来源:百度文库 编辑:神马品牌网 时间:2024/05/10 11:49:43
SELECT bmmc
FROM mj_recvdata
GROUP BY bmmc
HAVING COUNT(bmmc = 'xxx')
我要汇总bmmc=xxx的总共有多少条
FROM mj_recvdata
GROUP BY bmmc
HAVING COUNT(bmmc = 'xxx')
我要汇总bmmc=xxx的总共有多少条
SELECT COUNT(*) AS total
FROM mj_recvdata
GROUP BY bmmc
HAVING bmmc='xxx'