having经常和group by 联用,并且having需要和聚合函数应用。
例如查询num出现至少三次的num
select distinct Num as ConsecutiveNums from Logs
GROUP BY Num
HAVING count(Num)>=3
sql之having用法
最新推荐文章于 2024-06-24 21:06:07 发布
having经常和group by 联用,并且having需要和聚合函数应用。
例如查询num出现至少三次的num
select distinct Num as ConsecutiveNums from Logs
GROUP BY Num
HAVING count(Num)>=3