尼坤宋茜接吻照片:请高手帮我看一下这个查询语句有何错误
来源:百度文库 编辑:高校问答 时间:2024/04/29 17:03:29
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'