自制铅笔袋:请高手帮我看一下这个查询语句有何错误
来源:百度文库 编辑:杭州交通信息网 时间:2024/05/03 03:07:05
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'