select url,convert(varchar(10),cast(visitime as datetime),120) as 日期,count(*) as 日访问
from T_20051122
group by url,convert(varchar(10),cast(visitime as datetime),120)
select url,convert(varchar(7),cast(visitime as datetime),120) as 月份,count(*) 月访问
from T_20051122
group by url,convert(varchar(7),cast(visitime as datetime),120)