Oracle 中 where 与 having 之间的区别

having 和where 都是用来筛选用的

having 是筛选组  而where是筛选记录

他们有各自的区别

1、当分组筛选的时候 用having    

--- example:         select t.callingnumber,count(*) from t_message_info t group by t.callingnumber having count(*) > 2

2、其它情况用where

Having 是在结果集聚合之后，对结果集进行过滤。

 一个含有Having 子句的的SQL 并不一定含有GROUP BY 语句

 如：SELECT STORE_NAME ,SUM(SALES) FROM STORE_INFROMATION GROUP BY STORE_NAME HAVING SUM(SALES) > 1500