传奇素材添加视频教程:请高手帮我看一下这个查询语句有何错误
来源:百度文库 编辑:高考问答 时间:2024/05/10 17:45:44
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'