这个查询，应该怎么写呢？
本帖最后由 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
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)>=8
order by a desc
