这个查询，应该如何写呢

这个查询，应该怎么写呢？
本帖最后由 linshilong 于 2013-01-20 16:01:34 编辑



SELECT ip,count(ip) as a
FROM [WZll].[dbo].[CnzzContent17] as main 
where dtime between '2013-01-10 00:00:00' and '2013-01-17 23:59:59' 
and lzi like '%baidu%' 
and Zluye like '%?%' 
group by ip 
order by a desc

下面是我的，查询结果
ip a
220.161.148.210 22
220.161.148.211 16
220.161.148.212 10
220.161.148.213 9
220.161.148.214 8
220.161.148.215 8
220.161.148.216 8
220.161.148.217 8
220.161.148.218 7
220.161.148.219 7
现在我只想让a的查询结果，大于8的出现也就是下面的结果
ip a
220.161.148.210 22
220.161.148.211 16
220.161.148.212 10
220.161.148.213 9
220.161.148.214 8
220.161.148.215 8
220.161.148.216 8
220.161.148.217 8

要上面的查询结果，语句应该怎么写呢 sql
[解决办法]

SELECT ip,count(ip) as a 
FROM [WZll].[dbo].[CnzzContent17] as main  
where dtime between '2013-01-10 00:00:00' and '2013-01-17 23:59:59' and lzi like '%baidu%' and Zluye like '%?%' 
group by ip HAVING COUNT(IP)&gt;=8
order by a desc

这个查询应该如何写呢

热点推荐