2017年华润史宏超:请高手帮我看一下这个查询语句有何错误
来源:百度文库 编辑:查人人中国名人网 时间:2024/05/04 13:07:40
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'