oracle 之where子句和having子句

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