sql之having用法

having经常和group by 联用，并且having需要和聚合函数应用。
例如查询num出现至少三次的num
select distinct Num as ConsecutiveNums from Logs
GROUP BY Num
HAVING count(Num)>=3