1.where 不能放在GROUP BY 后面 2.HAVING 是跟GROUP BY 连在一起用的,放在GROUP BY 后面,此时的作用相当于WHERE3.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
oracle 之where子句和having子句
最新推荐文章于 2022-08-12 15:33:26 发布