1.where 不能放在GROUP BY 后面 2.HAVING 是跟GROUP BY 连在一起用的,放在GROUP BY 后面,此时的作用相当于WHERE
3.WHERE 后面的条件中不能有聚集函数,比如SUM(),AVG()等,而HAVING 可以
具体说明
select mobile from table1 where sum(score) = 1
group by mobile
报错
应该是
select mobile from table1 group by mobile having sum(score) = 1